Thread: Filter PivotTable dropdown items to match report filter
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Catherine D Catherine D is offline
external usenet poster
  
Posts: 4
Default 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
Reply With QuoteReply With Quote