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:
Check all PivotTables you would like to be affected by the slicer, and that’s it!
