Zeros in pivot table and charts but surpress when value is null is unchecked

[tinkerz1]

Hi,

I have no zeros in my pivot tables and charts but surpress when value is null is unchecked so I expected to see them?

I am using a crosstable import from excel.

Is there another setting?

Thanks,

Neil.

[sunny_talwar · Accepted solution]

Is this what you want?

Forced your second expression to be null when its 0 using this expression:

=If(Sum({<Measure={'Amber Threshold'}>}Data) <> 0, Sum({<Measure={'Amber Threshold'}>}Data))

Is that what you wanted? Attaching your qvw for reference as well.

HTH

Best,

Sunny

[tinkerz1]

Brillant thanks that worked so well

[sunny_talwar]

Awesome

I am glad I was able to help.

If you got the solution you were looking for, I would suggest marking the correct answer and helpful answers to close this thread.

Best,

Sunny