Forum Discussion
Problem with Drill-down pivot table
Sorry about that. Our system has an automatic spam filter. Every weekday, our team manually goes through the spam quarantine and moves messages out of it that don't belong. I've unmarked your posts as spam.
Feel free to delete any extraneous/repeat posts as I wasn't sure which was the one that best represented what you wanted to say.
- Does the workaround above not work for you Mielkew ?
I have the same issue has this been resolve? Anyone can share input how to overcome this in PowerPivot? Appreciate any input from you guys Wyn Hopkins
Sounds like an old bug that should have been fixed but clearly isn't
https://contexturesblog.com/archives/2012/03/22/drill-to-detail-with-excel-slicer-filters/
The workaround sounds like you also add the filters in your slicers to your filter pane of your pivot.
Not great
Sounds like an old bug that should have been fixed but clearly isn't
https://contexturesblog.com/archives/2012/03/22/drill-to-detail-with-excel-slicer-filters/
The workaround sounds like you also add the filters in your slicers to your filter pane of your pivot.
Not great
- Thanks for jumping in Wyn.
- My Excel version is newer: version 1808, bld 10730.20053 (click to run)
Very interesting, when I make a double click on "I2" in sheet "Table loaded in PowerPivot" I get 12 records. From sheet "Table direct Pivot" I get correctly 3 records back.
Is my Excel / PowerPivot broken? My colleagues have the same issue.
I have this Excel Version (2016) and Build:- If I DL your example file and double-click cell I2 on either worksheet, I get a new worksheet inserted (as expected). Both new worksheets contain the same three records:
ID Provider Shipper Country Consignee Country Weight
18 TNT CN DE 67.7
17 DHL CN DE 10.1
4 UPS DE DE 27.8 - Hello Jan Karel,
this workaround won't help. I've added all slicers to the page filter. The result of the drill down is still wrong, when the data source is coming from Power Pivot.
