Make 2 Pivot Tables in same items

[Guest]

Dear Sirs,

There are 2 PVTs in one worksheet, they are PVT1 and PVT2. They are 2
exactly same PVT. In page area, there are selections of shops, year. In the
row area, there is month. In column area, there are categories and products.
When I make different selections in categories and products in PVT1, I need
PVT2 change as well. Can I do that? Can someone help?

 

[Debra Dalgleish]

There's a sample file here that you could adapt to your worksheet:

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

Under PivotTables, look for 'PT0008 - Change Multiple Page Fields'