3 Replies Latest reply: Jun 28, 2017 11:42 AM by Reiko Hayami 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.

       

      COUNT({1<StateValue={"Active"}>}if((today()-IncidentDate<15),1))

       

      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.