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

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.

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

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

auntmarsa wrote:
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.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html