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....

excel

JKPieterse

Silver Contributor

Aug 30, 2018

I would need your workbook to try and figure out what the problem is.

null null

Copper Contributor

Aug 30, 2018

Hello Jan Karel,

I cannot add an attachment. It's always marked as spam. Very strange.

So here is a link to an example file:

https://drive.google.com/open?id=0B26mQbliZPiyakFpVEoyQUtWR0Z1QjBZLW5DWmFLQklkSThB

I've created two worksheets. One uses PowerPivot, the other one gets the data directly from the worksheet. I've also already set the filters. Try a drill down in both sheets. You will see different results. The one from the data model in PowerPivot will return a wrong result.

Best regards,

Virty

Forum Discussion

Problem with Drill-down pivot table