Hi

Wondering if anyone knows how to filter a 2nd pivot table with the inverse of a slicer, alternately 2 slicers with the second one doing the inverse of the first?

Scenario:
I have 2 pivot tables, first pivot will show the list of people in a team by selecting team A in a slicer, the second pivot will show people in every other team e.g. Team B & C and will exclude the people in Team A. Rather than having a second slicer linked to the second pivot to deselect Team A, is there a way to make both pivots work off the one slicer but the 2nd pivot do the inverse?

Thanks in advance.