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