Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Dimension Tab,
suppress when value is null
Presentation tab:
suppress missing
suppress zero values.
in dimension limit
check show others for other values