Hello. I have this slicer and its beast mode below:
Here's what I want to achieve:
If Project Maya is selected, the column 'Action' should show only 'Disregard' results.
If any of the other 3 was selected, the column 'Action' show only 'Resolved' results.
Not sure if nested case when statement will work on this. Please help.