Hello, everyone! I have a simple pivot table that includes parent account and account as dimensions and then displays a number of numerical expressions. If there are no selections/filters, the pivot table shows all parent accounts and then all individual accounts nested underneath each parent, followed by the values. However, if a user filters on a particular account, instead of limiting the pivot table to a single row with that account, I'd like the pivot table to limit on the parent account dimension instead so that the user can see each of the related accounts rolling up to the same parent as the one selected. Is this possible? I cannot use parent account as the filter because there are other objects on the sheet that would be adversely affected. Thanks in advance for your help!
Here's an example:
If the user filters on Account 1, I want the pivot to show all the values for its Parent Account (1-4) and not just limit the pivot to the row for Account 1.