Pivot Tables - Page Area

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.
 
D

Debra Dalgleish

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
Combining and merging lines 1
Are Date filters available for items in the Filter area of pivot t 2
Excel Pivot Tables 1
Dynamic PivotTable List 1
2 Files with Different Fields 6
pivot table format 1
Help me please!!! Excel 2003 3

Top