Suppress null values in pivot table

[rsdhavle]

HOw can we supress zero values in Pivot table? is there any limitation? I am not able to avoid zero values in the table

[#2]

give the condition which u gave in the expression in the dimension tab as calculated dimension and check the box suppress when null values.....

[#3]

In presentation tab check suppress zero values

[#4]

Can you attach a sample app.

[#5]

Suppress the zero values of dimension by goto dimension tab and check the option Suppress when value is null or go to presentation tab and check the option suppress zero values.. Hope this will help you

Regards

Bhawna

[rsdhavle]

its not working

[#7]

Hi Rohan,

Chart properties-> Presentation->

hope this helps

[#8]

Use the IF condition in the experssion to avoid the null values.....but the above methods are the way to avoid the null values in the pivot table...