| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter PivotTable dropdown items to match report filter
In an Excel 2007 PivotTable, I want the dropdown list of Departments to match
the chosen Faculty (Faculty is the report filter). In the default PivotTable I have a listing of all the Departments at the institution. I know I can separate the data and make several PivotTables but I wanted to preserve all the data in one table. Thanks, Catherine -- BC, Canada |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filter PivotTable dropdown items to match report filter
The Report Filters aren't dependent, and there's no setting you can
adjust that will change that. Each dropdown list will show all the items in its field, not just the ones that match a selection in another Report Filter. Catherine D wrote: In an Excel 2007 PivotTable, I want the dropdown list of Departments to match the chosen Faculty (Faculty is the report filter). In the default PivotTable I have a listing of all the Departments at the institution. I know I can separate the data and make several PivotTables but I wanted to preserve all the data in one table. Thanks, Catherine -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filter data in a PivotTable report in value area | Excel Worksheet Functions | |||
| Report Filter in PivotTable | Excel Discussion (Misc queries) | |||
| filter: how to print filter list options in dropdown box | Excel Discussion (Misc queries) | |||
| Excel 2007 PivotTable Report Filter area not working | Excel Discussion (Misc queries) | |||
| Print Pivottable - show all selected items in page filter | Excel Discussion (Misc queries) | |||
Hybrid Mode
