Relational pivot table filters

R

Ranga

Using Excel 2003, I want to have relational pivot table filters. For
example, when using a hierarchy, I have filters for level 2, 3, 4
etc. I only want to see the level 3 items in the drop-down list that
relate to the level 2 selection, so on and so forth.

Is there a way to do this?
 
D

Debra Dalgleish

No, the pivot table report filters aren't dependent on the other filters
and there's no way to change that behaviour.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to filter only the first level in the hierarchy 2
PIVOT - Reference a cell outside the table for report filtering 2
Problem with Calculated item in Pivot Table 1
2003 Pivot Table Filter (items dropped in the Page Fields) 1
Pivot Table 1
pivot table filter 6
Top X% in Pivot Tables 1
Pivot Table Report Filter - "OR" instead of "AND" Multiple Filters 1

Top