How to connect 1 Slicer to 2 different PivotTables - Excel 2010

[Legacy 227120]

I am working with PivotTables and Slicers. However if I can first explain the scenario:

• I am collating data from a table that is updated every month. I transfer the table into Excel 2010. The column titles on the monthly tables are always the same, it is the data that changes.
• For example, I have the xls spreadsheets from August 2012 and September 2012. From these 2 tables I create a PivotTable for both months, structuring them exactly the same.
• I then Place both PivotTables side by side on the same page.
• I then inserted a Slicer for table A.

I would like to know if I can get the Slicer to control BOTH PivotTables at the same time, bearing in mind that both PT's are drawing their data from different sources.
Please help!

 

[exceliz]

great thread! - i also am struggling solution....

 

[ratherbegliding]

Hi,
As said previously, use Power Query to merge both data sets into one single table.
Then create two independent pivot tables from the merged table.
Only then will you be able to use a single slicer to filter both pivot tables simultaneously.

Good luck!

 

[ashley8905]

I was able to solve my problem by hit and trial... if anybody want help on how to do the same, just send across a message of reply on this thread

Hi I am stucked on this problem now..Wanted to share one slicer with two pivot tables from different source in the same sheet.
Can you help?
Thanks very much!
Awaiting your response