Hide rows with zeros in UX
I have a UX grid, which has a couple of dimensions. Depending on what selections they make using the selectors the grid can show rows with zeros in all columns. How can I automatically hide rows with zeros? I don't think I can link to a boolean with a formula like 'Show = Actuals <> 0' because the selection can change (if they choose Budget not actuals then the Show formula would be wrong).