I know that in a Pivot Table, if you double click a results cell, you can get ShowDetails to create a new worksheet with details behind the results cell.
What I'd like to do is to be able to click a results cell in a pivot table (not double click), and have just part of the details behind that cell appear in cells that are just offset from the pivot table itself.
I believe part of this solution will involve finding out the values of the row grouping items in the pivot table.
Can anyone point me in the right direction? Assume I group on fields AA and BB from my original data and sum over CC.
Thank you in advance!
Bruce
Bookmarks