filter within a filter


E

Erik

Is there any way to run more than one filter from the drop down menu? I have
a large pivot table and am trying to create a filter, or set of filters to
help narrow down to more specific information for easy maneuvering in
presentations and help in general. As of now, when I create multiple
filters, it will only use one of the filters. Example, it will only narow my
entire pivot table by one selected field. I would love if there was a way
that I am missing that would allow me to do something like this. Have the
filters land use, (retail, office) and company, (A,B). I use the land filter
and select office. When i click on the company filter I would like to be
left with just the list of companies who own office properties. I hope that
made sense and thank you in advance
 
Ad

Advertisements

F

FARAZ QURESHI

Why not use the same field more than once in the same pivot field? Filter
one, then use the same other field for further filteration!
 

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

Top