| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
filter in a filter
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DataFilterAuto Filter in excel 2007? | New Users to Excel | |||
| Filter PivotTable dropdown items to match report filter | Excel Discussion (Misc queries) | |||
| Copy only visible cells after filter is applied/ sum after filter | Excel Worksheet Functions | |||
| Advance filter search does not filter an exact match | Excel Programming | |||
| "Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
Hybrid Mode
