How do I link 2 pivot tables together? ie. If I filter on one pivot table I
would like the other pivot table to filter to the same criteria. All data is
from the same source.
thanks,
Carrie
How do I link 2 pivot tables together? ie. If I filter on one pivot table I
would like the other pivot table to filter to the same criteria. All data is
from the same source.
thanks,
Carrie
I suggested the following, when you posted this question a few days ago:
'============================
There's a sample file here that changes the page field in all pivot
tables, when the master pivot table is changed:
http://www.contextures.com/excelfiles.html
Under Pivot Tables, look for 'Change Page Field'
'======================
Do you try this and have problems?
carrie wrote:
> How do I link 2 pivot tables together? ie. If I filter on one pivot table I
> would like the other pivot table to filter to the same criteria. All data is
> from the same source.
>
> thanks,
> Carrie
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks