How to avoid 0.00 values in the table

[#1]

HI,

i am using pivot table to list the pdtname,currentmonthsale,previousmonthsale...

when i selected any one of the product in the table,the other unselected values of currentmonthsale,previousmonthsale...are became 0.00 ,So it disturbs the expression values calculation in the sheet and others,how to avoid this and i need the exact data to be displayed.

Pls,help me out....

Thanks in advance...

[Anonymous]

HI, btechrames

>you can go to the property menu>presentation>supress_zero values(mark).this will supress all zero values.

[#3]

That too was checked eventhough its coming ,i need that it wont affect other columns,,,,,,,,,

[Anonymous]

Can anyone respond to this question please?

[Anonymous]

Hi,

in expression you convert the value like this  and give supress_zero in presentation tab.

num(sum({<OpexFY={$(=Max(OpexFY)) }>}OrderedAmount),'#,##0')