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?

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

Ranga wrote:
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?


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com