CODEWITHSUNDEEP
sql-serverexcelssaspivot-table
Konrad Z.
Konrad Z.

Reputation: 1652

Using single slicer to control two pivot tables with different data source in Excel

I have a problem with slicer in Excel file. In my Excel file I have two worksheets. In the first one, there is a pivot table taking data from OLAP cube and in the second I have a pivot table taking data from another Excel file. I'd like to have one slicer called "Organization" to filter data in both tables. Is it possible?

Kind regards

Upvotes: 0

Views: 44127

Answers (1)

Stepan1010
Stepan1010

Reputation: 3136

No - it seems not. Slicers are meant to be used on pivot tables that share the same data source it seems. You should be able to conglomerate your data into one source and create two pivot tables with a shared slicer though.

From Microsoft: http://office.microsoft.com/en-us/excel-help/use-slicers-to-filter-pivottable-data-HA010359466.aspx

Make a slicer available for use in another PivotTable

1.Click the slicer that you want to share in another PivotTable. This displays the Slicer Tools, adding an Options tab.

2.On the Options tab, in the Slicer group, click PivotTable Connections.

3.In the PivotTable Connections dialog box, select the check box of the PivotTables in which you want the slicer to be available.

Or you could just create one pivot table.

Or you could have a look at this: Making all pivot tables on one sheet mimic each other in terms of rows expanding and collapsing

Good Luck.

Upvotes: 3

Related Questions