Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
emp id sal
0
a 1 3
b 2 5
c 3 7
i used straight table
iam getting 0 in first column
i user suppress ,missing values in property tab but still iam getting 0
please help
In your expression
Try below
If(sum(sal)>0,sum(sal))
Regards
ASHFAQ
Can you explain what expression you use.
In dimension tab check the box "Suppress where the values are null"
Try with
If( sal > 0 , Sum(sal))
Or
If(Sum(sal) > 0 , Sum(sal))
Or you can try with suppress values form option chart properties >> Presentation >> Suppress Zero-Values