Cascading drop down filter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
There's no setting you can change to make the pivot table's page fields
dependent on the selection in another page field.
 
You must log in or register to reply here.

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

Filter out rows based on the value of a cell 4
Cascading combo/query in tables 0
Access Cascading combo/query in table/subform 0
Update Filter List AFTER Filter Applied 3
removing autofilter sort options 4
autofilter count 1
Filtering Columns 5
Limit on filter drop-down list? 1

Back
Top