Dimensions with Zero (0) Value hide in Pivot Table

[americanetsMD]

Hello Everyone, 

i have the following small problem. I have created a Pivot Table where i should be able to see the sums for every Konto. The Problem is that i cannot hide those Kontos that have no values at all. If there is a value for a period only, all other periods get zero(0). If there is no value in any Period, the Konto should not appear in the table. attached you have a screenshot of the table. Has anyone an idea of how can i achieve my target here.

P.S the Add-On works, but it also replaces all Zero with (-) Null values...

[Or]

Zero values will show by default. You can disable this using the "Include zero values" toggle under Add-ons.

[americanetsMD]

Hi Or, that's a great idea, but i need to still show the zeros for those Kontos, if they have a value greater than zero in any periods.. see the screenshot above. 😞

[Or]

That is exactly how it works. If there's a single non-zero value in a row, it will be displayed.

[americanetsMD]

Hi Or, thank you for your support  🙂

The thing is that when i disable the "Include zero values" i get these Null(-) values..(See the picture attached) and the total row on top also dissapears when total = 0.  What i need is to surpress those Kontos that have value Zero in all Periods. The others that have at least one value in one Period, have to show value = 0 in all other Periods.