Linking PivotTable Fields - Excel 2007

J

Jim

I have two PivotTables that are set up on different data sources but with the
same report filters. Some of the report filters have multiple items chosen.
I want to change the report filter in PivotTable 1 and make sure the report
filters in PivotTable 2 are the same. I can't write a formula as both cells
read (Multiple Items). Any suggestions on how I can make it work?
 

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

Similar Threads

Slicers and Calculated Items in Pivot Table 2
Filter PivotTable dropdown items to match report filter 1
Link PivotChart to PivotTable, whilst hiding fields 0
Multiple PivotTables 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Pivot Tables/Charts and common filter 1
PivotTable Field Value List Update 0
Excel 2007 compatibility issue - speed between cells 2

Top