4 Replies Latest reply: Apr 4, 2018 5:44 AM by Sudhakar Battula RSS

    Hide 0 Value Rows in Pivot or Table

    Reiko Hayami

      Hello - I have a simple case aging table and StateValue field has Active, Canceled, or Resolved. I have the measures to count only the Active cases by expression, and it is working as below.




      Is there a way to just show totals in 1 row and not show the other rows, canceled and resolved because they would be 0 anyways?  I tried hiding zero value option but it does not seem to work. I don't actually need to show StateValue.  I just want to show total Incident counts by these aging, but there really isn't a dimension I can use to show just 1 row.  Thanks for help.