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.
 

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

Help with Formula 4
email as pdf print area excel 2007 1
How do you link list boxes 2
Are Date filters available for items in the Filter area of pivot t 2
Using Filter more than once 2
Combining and merging lines 1
Using Forms in my spreadsheet 3
Custom Filter? 2

Back
Top