Hide 0 Value Rows in Pivot or Table

[#1]

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.

[jaumecf23]

In the dimension you can create a Calculated Dimension, something like that:

=if(StateValue='Active',StateValue)

Using that like a Dimension you will only face the Active information

[kvanandan1 · Accepted solution]

Hi Reiko,

In the Pivot table property, there is a section 'Add-on' in that uncheck 'Include Zero values' option.

[#4]

That was the last place I would look at. !  Thank you so much.  That did the trick.

[bvssudhakar]

Hi Anand,

Where is that 'Add-on' Section, Can you please tell me because i am unable to find that section

I want to hide the rows of empty cells for pivot table

Please help me out from this

Thank you in advance

Sudhakar B V S