How to Auto-hide line items
I have a table which include value from Q1 FY21 to Q4 FY23 as line items, and want to hide which the value is 0. But when I use filter on line item will hide other line items like KPI Name (it is TXT format). How can I hide these line items which value is 0 and does impact other no number format line item? Thanks!