Hello,
Im trying to create multiple pivot tables which synchronize on the same filters. I also have slicers which are linked to all the pivots. The problem is that while the slicers work synchronously with the pivots, the filters only seem to impact the ONLY one table at a time.
Im trying to find a way such that:
either the filters are connected across tables
Or the slicers connect to the filters
Ive been looking online for so long and all results I found talk about slicers and avoid filters - I need both.
Im using Excel 2010.
Thank you!
Im trying to create multiple pivot tables which synchronize on the same filters. I also have slicers which are linked to all the pivots. The problem is that while the slicers work synchronously with the pivots, the filters only seem to impact the ONLY one table at a time.
Im trying to find a way such that:
either the filters are connected across tables
Or the slicers connect to the filters
Ive been looking online for so long and all results I found talk about slicers and avoid filters - I need both.
Im using Excel 2010.
Thank you!