Filtering different PivotTables using one filter

Imagine that you have several pivot tables, and you want one filter that will affect all of them.

Is it possible?

It’s possible!!!

If you insert a slicer for one of the tables (starting with version 2010),
you can access the slicer tab and choose “Report Connections” for the PivotTable:
Report Connection

Check all PivotTables you would like to be affected by the slicer, and that’s it!

Do you think it was helpful? Share it with your friends