Cascading drop down filter

[Francisco]

Hi:

When applying several filters I haven't found a way to make the dropdowns
show only the options left available after I have chosen a filter on another
dropdown. I mean like the autofilter functions works. When you filter one
dropdown the others still show all options, even those that are not available
anymore. Can anybody help me with this?

Thanks a lot in advance for your help,

Francisco

 

[Francisco]

Sorry, forgot to say that I mean the dropdowns on a Pivot Table

 

[Debra Dalgleish]

There's no setting you can change to make the pivot table's page fields
dependent on the selection in another page field.