I am looking for a way to show dependent data in page filter in a pivot table.
ex, 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 the 'north' region, still shows unfortunately all numbers and not just 1,2 and 3.
Is there a solution for the problem as described above?
Thank you,
ex, 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 the 'north' region, still shows unfortunately all numbers and not just 1,2 and 3.
Is there a solution for the problem as described above?
Thank you,
