Delete rows that only contain 0 (zero) as value

[#1]

Hello

I got several pivot tabels that hold rows where all values are 0 or empty.

By default I always get a row with "-" in the dimensions of the pivot tabele.

How can I get rid of them so I don't see them anymore?

Thanks Peter

[Gysbert_Wassenaar · Accepted solution]

Make sure the option Suppress Zero-Values is enabled on the Presentation tab. And that Show All Values is not enabled for the dimensions of your pivot table

[#3]

So somehow that dosn't work here, I still got rows in the pivot where all values are 0. Can it cause of the dimensions, so I got QuarterYear and inside the Month, where for example two months have only 0 values.

[#4]

Hi Peter,

Would it be possible to provide us with a small data sample where you are experiencing the issue?

[deepakqlikview_123]

use isnull function.

Thanks

[#6]

Okay, so my problem was that I didn't tick the "don't show NULL' not for all dimensions