No, the page fields in a pivot table aren't dependent on what's been
selected in another page field. All the items will show in the dropdowns.

Allen wrote:
I have a pivot table that includes data segmented by state and county among
other things. They are in the header portion of the table, not a column or
row. I'd like to make it so that whenever someone selects a state, only
counties from that state are visible in the county drop down. Is this
possible? Thanks for any help.


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com