How would you connect the slicer to both PivotTables?
You cannot use one slicer for two PivotTables.
Right-click the slicer and select Slicer Settings.
Merge the two PivotTables, right-click the merged PivotTable, and select Combine Slicer.
Right-click the slicer and select Report Connections, or click Report Connections on the Slicer tab. https://sfmagazine.com/post-entry/may-2020-excel-sharing-a-pivot-table-slicer-between-multiple-data-sets/
