Forum Discussion
Applying filter inside IF ELSE condition
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...
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
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 |