Forum Discussion
John McClaskey
Mar 18, 2018Copper Contributor
dynamic display of pivot table item details
Right-click on a cell in a pivot table and "show details" will give you fixed list in a new worksheet of the items underlying the entry. I would like this to be dynamic so it would show the items for...
JKPieterse
Mar 19, 2018Silver Contributor
This might help:
https://superuser.com/questions/443183/how-to-filter-source-sheet-in-excel-pivot-table-drill-down
https://superuser.com/questions/443183/how-to-filter-source-sheet-in-excel-pivot-table-drill-down
- John McClaskeySep 30, 2018Copper Contributor
This is a very belated thank you. Perhaps because I had not provided my profile with an email address, I never saw this at the time and shortly thereafter abandoned development of the relevant spreadsheet. I have now returned to it and see your reply. I haven't tried it yet, but the code you linked me to may provide the needed functionality.