I am looking for a way to show dependent data in a pivot table.
For instance, when I select a region, I would like to see only the related items to that region, not all possible items.
Region number
North 1
North 2
North 3
South 4
South 5
South 6
When creating a pivot table, I put these values in the page section.
Selecting a region and than the number, shows unfortunately all numbers and not just 1,2 and 3.
I’m thinking of creating a filter, copy the found data en than make a pivot table. The problem than is that when an other region is selected, I should update the filter and than update the pivot table, so that isn’t really a solution.
Is there a solution for the problem as described above?
Greetings
ncb
Bookmarks