Slicers not linking all Pivot Tables

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

Please use add to the Data Model on all Pivot tables

1. Create Table CO for "CAPEX" or "OPEX" and add to the Data model.
2. Create Relationship to all Table by go to diagram view and drag CO to CAPEX/OPEX
3. Add report connection for slicer

CO.png

A table cannot overlap

Delete Manpower Pivot table and create new Pivot Table and place it at Pivot!A60 and also check add this data to the data model.