Pivot Tables - Page Area
 

Hi.

Is it possible to have tiered filters in the page area? For example, if I
have 3 columns selected for the page area, State, County and ZIP, is there a
way that if I select a single State that when I go to choose a county, it
only displays the county in that state? I don't want to have to put those
columns in the data area but just be able to filter by that criteria.

Pivot Tables - Page Area
 

No, there isn't any setting that will make the page fields dependent on
selections in the other page fields.

Christine wrote:
Is it possible to have tiered filters in the page area? For example, if I
have 3 columns selected for the page area, State, County and ZIP, is there a
way that if I select a single State that when I go to choose a county, it
only displays the county in that state? I don't want to have to put those
columns in the data area but just be able to filter by that criteria.


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