How to remove zero value in straight table?

[#1]

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

[ashfaq_haseeb]

In your expression

Try below

If(sum(sal)>0,sum(sal))

Regards

ASHFAQ

[its_anandrjs]

Can you explain what expression you use.

[hannan_t]

In dimension tab check the box "Suppress where the values are null"

[its_anandrjs]

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