View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Christine Christine is offline
external usenet poster
 
Posts: 147
Default 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.