In order to make these all mutually exclusive, you would need to create multiple calculated fields - one for each of the conditions. An IF statement can only return one result.
Hope this helps!
Is there a way to get the multiple calculated fields into one filter?
EDIT: I tried creating a combined field with all of them, but it's incredibly unwieldy and ugly, and it returns a few extra filter options that I don't want. Not sure if there's a way to clean it up.
1 of 1 people found this helpful
You could do a parameter, but not a filter. A filter looks at a single field/row. A parameter can look at additional things.
You can setup your filter field to be something like this:
[myParam] = 'ALL'
[myParam] = 'ABC' AND [ABC Calc] = 'ABC'
[myParam] = 'C' AND [C Calc] = 'C'
[myParam] = 'DEF' AND [ABC Calc] = 'DEF'