Forum Discussion
Problem with Drill-down pivot table
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
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:
- 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)
