Pivot Tables - Page Area

  • Thread starter Thread starter Christine
  • Start date Start date
C

Christine

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.
 
No, there isn't any setting that will make the page fields dependent on
selections in the other page fields.
 
Back
Top