Worksheet Filter AND / OR logic
During an analysis, a user may want to show for a specific deviation (for example Actual vs Budget) all items that have a deviation of -1000 OR +1000.
Next time he uses the same worksheet, this may be a different boundary or even a different line item (for example Actual vs LY). In classic UX, this was simply possible via the filter function ALL / ANY (see picture 1).
The NUX worksheet allows currently only AND logic, OR is not possible (see picture 2).
Current workaround is to follow best practises and create a boolean formatted line item hosting the filter logic.
However, this approach has limitations or would require a complex technical solution when the filter is (1) user based and (2) the criteria is largely variable.
In such use cases, the built-in worksheet filters offer an easy and very helpful solution.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.