One Pivot Table changes another

[todtown]

I have two pivot tables. One is based on the other, so the data for
both of them is identical. However, I want the second pivot table to
change when the first one does. For example, the user chooses a pull
down for one of the fields and unchecks an item (hides it). I'd like
that same item to be hidden on the second pivot table. Could someone
tell me how to do this?

tod

 

[Debra Dalgleish]

There's 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