Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Supress Zero Values in Pivot Table

I got a question, how to supress Zero values in a Pivot table.
My Data Source looks like this:

DateSourceError 1Error 2Error 3Error 4Error 5Error 6Error 7Error 8Error 9
23.07.2010A68656710
23.07.2010B16391130

I generate a Standard Table and it looks like this:

error loading image

Here the same a a Pivot table:

error loading image

I used Source as Dimension and sum(Error 1), Sum(Error 2) ... Sum(Error 9) as Formula.
I tried to use the "supress zero" checkbox. That works only, if there are Zeros in every Formula (Error 1 - 9).
As far as there is a value greater zero in any of the formulas, the privot table is showing all 9 formulas.
Is there a Possibility to supress that?

Thanks for your help.

1 Solution

Accepted Solutions
Not applicable
Author

Hi dj-kalle,

Please find the attached document for the reference.

I think this will help you .

Regards,

Ravi

View solution in original post

3 Replies
Not applicable
Author

Hi dj-kalle,

Please find the attached document for the reference.

I think this will help you .

Regards,

Ravi

Not applicable
Author

Hi Ravi,

Thank you for your answer! Did i understand you right, that i have to change my data model, to bring my row titles (Source, Error 1 - Error 9) into one column?

Regards, Martin

Not applicable
Author

Now its working: I created another table with "crosstable load" and joined it over an id to my original data. Then i created two dimensions like in Ravi´s Example. Now ist works and the zeros are supressed! Thanks a lot!