Question: How would you connect the slicer to both PivotTables?

1. You cannot use one slicer for two PivotTables.
2. Right-click the slicer and select Slicer Settings.
3. Merge the two PivotTables, right-click the merged PivotTable, and select Combine Slicer.
4. Right-click the slicer and select Report Connections, or click Report Connections on the Slicer tab.

Answer: The correct answer of the above question is Option D:Right-click the slicer and select Report Connections, or click Report Connections on the Slicer tab.