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....
Hello
Yeah but that's the thing, it doesn´t make any difference having the slicer fields as page filters.
Attach an example of the workbook for clarification, see sheets Case 1a & b. Produce the same results with different filters.
Maybe it has something to do with my created measures in Powerpivot but can't figure out what could be wrong there
BR
Fredrik
Odd. If I filter for 40, I do get the expected 7 records, filtering for 42 yields 13 records and filtering for 40 and 42 gives precisely 20.