Link Pivot Table

[cyliyu]

Dear All,

How can I link 2 or more Pivot Table together, so that when I select or set the filter in one table, it will automatic update the others table.
I am not referring to the slicer.
e.g. when week 14 in pivot table 1 was selected, pivot table 2 will update too. Thanks.

 

[Chihiro]

Is your data source OLAP cube or Excel table/range?
Does all your pivot table share same data source?
These will impact what method(s) can be utilized.

I suggest you upload sanitized sample workbook to get help.

Two method that immediately comes to mind are...
1. Hidden sheet that house pivot with row label only (corresponding to filter fields)
Along with hidden slicer to link tables.

2. Macro to adjust visible filter item on multiple pivot, based on your selection.

Unless you are using Excel 2007 or older, I'd recommend first approach.

 

[cyliyu]

It was Excel Table/Range and same data source.

I managed to solve it by applying slicer and connect both pivot table together. Thanks.

 

[NPOKALA]

Dear All,

How can I link 2 or more Pivot Table together, so that when I select or set the filter in one table, it will automatic update the others table.
I am not referring to the slicer.
e.g. when week 14 in pivot table 1 was selected, pivot table 2 will update too. Thanks.

View attachment 46079

Please send in your sample excel files with the pivot tables