Pivot Table-two tables same data, can I used the same page control

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

On one page, I have a pivot table that shows total dollars by category, then,
below it I have a copy of that pivot table that calculates dollars/sq ft. Is
there any way that these two tables can be controlled by the same Page
choices. So, if I filter on a different country, it will change both the
first and second tables.
 
There's nothing built in that will allow this, but you could use
programming to change other tables when you make a selection from the
first pivot table.

There are a few sample files here that you could adapt to your worksheet:

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

Under PivotTables, look for
PT0016 - Change Page Fields With Cell Dropdown
PT0015 - Change Multiple Different Page Fields
PT0008 - Change Multiple Page Fields
 

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

Pivot Table Quesiton 6
Change Multiple Page Fields in two independent Pivot Tables 1
Pivot Table - copy specified Grand Totals 1
Consolidate information from multiple pivot tables 2
Calculated Item in Pivot table 1
Pivot Table (behind the scene) 8
linked 3 pivot table pages ????? 1
how do I combine two pivot table? 1

Back
Top