Remove Zero Value Rows from Pivot

[Sundance_Kid]

Hi,

I have a pivot table and for some of the rows there are zero values across the board for the full year, yet they still appear in the table. Is there a way to remove these lines without having to manually remove each row in the dropdown?

I have hidden the row name for confidential reasons.

Image attached for reference.

Thank you

 

[arthurbr]

You can use the filter to hide them

 

[Sundance_Kid]

Thanks, I am trying to see is there a quicker way to do it without having to use the filter? There potentially could be up to 40 rows to remove by filter.

 

[arthurbr]

With the filter you only have to remove one field...