topic Dimensions with Zero (0) Value hide in Pivot Table in App Development

Dimensions with Zero (0) Value hide in Pivot Table

americanetsMD — Thu, 02 Nov 2023 14:02:06 GMT

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...

Re: Dimensions with Zero (0) Value hide in Pivot Table

Or — Thu, 02 Nov 2023 14:12:59 GMT

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

Re: Dimensions with Zero (0) Value hide in Pivot Table

americanetsMD — Thu, 02 Nov 2023 14:16:21 GMT

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. 😞

Re: Dimensions with Zero (0) Value hide in Pivot Table

Or — Thu, 02 Nov 2023 14:27:02 GMT

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

Re: Dimensions with Zero (0) Value hide in Pivot Table

americanetsMD — Fri, 03 Nov 2023 11:30:28 GMT

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.