Blank field instead of zero values in pivot chart

[#1]

Hi everyone,

I want to set blank values in field insted of zero values in pivot chart. How to achieve this?

Tnx

[Anonymous · Accepted solution]

if the zeroes are a result of an expression, then try something like (replace sum(Product) with your expression)

if(sum(Product)=0,'',sum(Product))

[#3]

Tnx for fast reply

[Anonymous]

you are welcome!

[#5]

HI,

I want to Suppress the Blank Reccords also...

HOw Can I Acheive this ...

Regards,

Helen

[sskinner]

Seems messing with the expression is a awkward solution. The "Number" tab on expressions allows you to set a format pattern (e.g. #,##0), so you would think #,### would work to suppress the zero - but it does not (bug?). As an alternate solution, if you do not have negative values, you can use the "Visual Cues" tab to hide a zero value with a white color or 100% transparency.