how to supress null values & zero's in Barchart

[madhubabum]

Hi, All

Here i am taking as dimension as "Sub_Division" and Expression as Sum(      ) ...

Here i want to show others values as "others" on X-Axis ....& i want to remove zero's on my X-Axis .....

How to Achieve this one ..?

Thanks  To All

Madhu

[buzzy996]

on ur expression tab :

=if(sum( urfieldname)>0.1,sum( uefieldname),null())

on ur dimesnion tab:

check the check box, suppress when value is null

[#3]

Dimension Tab,

suppress when value is null

Presentation tab:

suppress missing

suppress zero values.

in dimension limit

check show others for other values