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 |
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 |
All times are GMT +1. The time now is 03:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com