I got a question, how to supress Zero values in a Pivot table. My Data Source looks like this:
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?
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!