Supress Zero Values in Pivot Table

[#1]

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

Date	Source	Error 1	Error 2	Error 3	Error 4	Error 5	Error 6	Error 7	Error 8	Error 9
23.07.2010	A					6	865	67	1	0
23.07.2010	B	1639	11	3	0

I generate a Standard Table and it looks like this:

Here the same a a Pivot table:

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.

[#2 · Accepted solution]

Hi dj-kalle,

Please find the attached document for the reference.

I think this will help you .

Regards,

Ravi

[#3]

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

[#4]

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!