| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I prevent access to other page area in pivot table report? | Excel Discussion (Misc queries) | |||
| Page field in pivot tables | Excel Discussion (Misc queries) | |||
| Pivot Table Page Field Area Broken | Excel Discussion (Misc queries) | |||
| Multiple selection in the page area of a pivot table | Excel Discussion (Misc queries) | |||
| I cannot drag a Pivot Table field into the page area | Excel Discussion (Misc queries) | |||
Linear Mode
