Pretty simple question but struggling to find any conversations around this already, so figured I’d ask.
I’m trying to filter a table on a column which can have five values (A, B, C, D, E), and I want to return all rows which are either “A” or “E”.
I know I can use AND in table filters, so I could simply do !Value “B” AND “C” AND “D”, but I predict more values will be added to that column in the future. Rather than having to constantly update my filter, I know I’ll only ever want “A” and “E”, so is there any way to do OR logic?
PS I’ve tried OR and || in the same way that AND and && work without success