Worksheet Filter AND / OR
maybe I'm missing something, but I couldn't find anything in the NUX documentation that AND / OR logic works with filters in worksheets.
During an analysis, a user may want to show all items that have a deviation of -1000 OR +1000. In classic, this was possible via the function ALL / ANY.
I just tested the same in a worksheet, but it seems to allow only AND and I couldn't find a way around it (see picture 2).
The only option would be to create a boolean formatted line item with OR logic and filter on this. Is this correct?
I thought this is quite common during analysis, so I wonder if somebody knows how to solve it without creating a calculated line item.
Otherwise I will post an idea.