Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Invert Selection

Hello,

 

I have a table like this:

 

Country          Product

US                     AA

UK                     BB

Australia            AB

NZ                     AA

Cannada            BB

 

If I I use a Slicer and select ''Product as AA"  -> I will get the list of Countries that uses product AA (US and NZ).

But, is there a way to display the Countries that doesn't use AA product i.e., If I select AA in Slicer, it should display UK, Australia and Cannada.

Any sort of help is much appreciated.

 

Thanks