I have 3 different pivot tables on the same sheet.

It's an employee commission sheet. The employee sold policies for 3 different products. On the sheet, it has his/her break down laid out in 3 pivot tables. Each different pivot table is for a separate product, and all 3 pivots are based off 3 DIFFERENT data sets (no way around this). I have 3 different slicers that have to be select on the same agent for in order for the commission sheet to be applicable.

Is there a way to make it so the 2nd and 3rd slicers equal whatever is select for the 1st slicer? It would be a name. All 3 slicers have the exact same options.


Thank you,
JPH