I have a list of variables, that can exist alone or together:
Apple, Pear, Orange, Banana, Ice Cream
I want a filter that looks for all the above variables EXCEPT Ice cream. And if Ice Cream and Banana are together, then I want that EXCLUDED also.
At the moment I'm using:
....AND platform in (Apple, Pear, Orange, Banana)
Which is filtering out Ice Cream (great), however whenever Banana and Ice Cream come along together, I can't find a way to filter that out.
Hope someone can help, thanks