How to Synchronize page fields for two or more than 2 pivot tables?

H

hittingtime

How to Synchronize page fields for two or more than 2 pivot tables?
I have two pivot tables that have the same page fields. I want them to
have the same page fields selections.

For example,
Page fields for pivot table 1 are: Product, Market;
If I choose product: A, B;
Market: JP, UK
for pivot table 1;

I want pivot table 2 have those selections automatically for those two
fields.

Regards.

Any one has any ideaes? Thanks.
 

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

Change report firlds in pivot tables and charts with one selection 0
Need some PWA help 0
How I can set dynamic pivot table ONLY when I have enough data point 1
How Do I Change Two Pivot Table Page Selections with VBA Code 1
How to have two tables on same line? 1
Format column widths from one table to a separate table on same page 1
How to create a bubble chart with more than 2 variables. 0
Using VBA on Excel Pivot Tables 3

Top