join multiple pivot tables?

  • Thread starter Thread starter clueless_in_mempjhis
  • Start date Start date
C

clueless_in_mempjhis

How can I link up multiple pivottables all based on the same data where all i
would have to do is change the page option (drop down menu) from the first
pivot and the rest of the pivots would automatically adjust to match those?
 
There's a sample file here in which you can change the page field in one
pivot table, and all the related pivot tables change:

http://www.contextures.com/excelfiles.html

Under Pivot Tables, look for 'PT0021 - Change All Page Fields' or
'PT0008 - Change Multiple Page Fields'
 
You must log in or register to reply here.

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

Unable to Group in Pivot Table 1
Pivot Table Automatically updation problem 1
Pivot tables not refreshing after data source update 1
Synchronizing Multiple Pivot Tables 3
Pivot table multiple filters 2
linking pivot table selections 2
Pivot Tables - Multiple Ranges 9
Used Range and Source data of a Pivot Table 1

Back
Top