Applying filter inside IF ELSE condition

[Anonymous]

Hi @jdbuchanan71, @Zubair_Muhammad, @Greg_Deckler , @parry2k 

I have a requirement like below,

I have a table (Employee) with 10 people in the Names field like below. Now in the report, I need a slicer with only 2 values.

1 is Include All Names - When I clicked on this option all the names in the table should display.

2 is Exclude Kapil- When I clicked on this option all the names in the table should display except Kapil. Can you please help me with this?

Name

Ajay

Bhanu

Chaitu

Siva

Sundar

Sai

Kapil

Vishnu

Vinod

Sasi

[jdbuchanan71 · Accepted solution]

@Anonymous 

Add a column to your table with the grouping you want.  Then put that column in your slicer.  You would just turn Kapil off to exclude them from the report, turn Kapil on to include all.

Name	Group
Ajay	Other
Bhanu	Other
Chaitu	Other
Siva	Other
Sundar	Other
Sai	Other
Kapil	Kapil
Vishnu	Other
Vinod	Other
Sasi	Other