Hide rows with zeros in UX

GeorgeDuckett
Regular Contributor

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).

10 REPLIES 10
MarkWarren
Expert

The line item you filter with would only apply to 1 LISS, so I'm not sure how a second LISS would come in to play. Does sound like we're trying to complicate things!