Applying filter inside IF ELSE condition

Question

Hi jdbuchanan71,&nbsp;Zubair_Muhammad,&nbsp;Greg_Deckler&nbsp;,&nbsp;parry2k&nbsp;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-&nbsp;When I clicked on this option all the names in the table should display except Kapil. Can you please help me with this?NameAjayBhanuChaituSivaSundarSaiKapilVishnuVinodSasi

jdbuchanan71 · Accepted Answer

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

Name
Group

Ajay
Other

Bhanu
Other

Chaitu
Other

Siva
Other

Sundar
Other

Sai
Other

Kapil
Kapil

Vishnu
Other

Vinod
Other

Sasi
Other

Forum Discussion

Applying filter inside IF ELSE condition

1 Reply

Related content

Apply data to all rows in a filtered column

Multiple Filter need to be applied by condition

Conditional Filtering

Apply Filter before Calculating Average

Grouped summaries with conditional filtering

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