Forum Discussion
Problem with Drill-down pivot table
Hi
I have three pivot tables with several slicers connected to each of the tables.
When I drill down to details in anyone of the tables it doesn't always reflect the filters from the slicers....
I would need your workbook to try and figure out what the problem is.
Hello Jan Karel,
please find attached an example file.
I've created two sheets (once the data is stored in Power Pivot and the other one catches the data directly from the work sheet) and I've set already the filters in the data slicer. Make a drill down and you will see, that you will get two different results. The one from PowerPivot will give you the wrong number of results.
Best regards,
Virty