Apologies if this has been covered before, but couldn't trace it if it was.
Attached workbook has five Pivot Tables on the Pivot sheet. Each Table covers two Projects and two classes of Cost (CAPEX and OPEX).
I want common Slicers for those two elements that filter all five Tables if you select a "Project" or choose "CAPEX" or "OPEX"
I set one pair up for the Total Cost pivot and tried "Slicer connections", but the list was not "seeing" the other Tables
All solutions, suggestions and alternatives welcome as ever.
Ochimus
Bookmarks