If condition not working

[sunitha_chellaiah]

Hi,

I am using value list in dimension. 

While using if condition in pivot table , the list is not showing all the values.

Dimension :

=ValueList('Cts','Gms','SP')

Expression :

 if(ValueList('Cts','Gms','SP')='Cts',sum(aggr(sum( DISTINCT NU_NETT_WTT),VC_VOUCHER_NO,VC_LABEL_NO)),
if(ValueList('Cts','Gms','SP')='Gms',sum(aggr(sum( DISTINCT NU_CARRAT_WTT),VC_VOUCHER_NO,VC_LABEL_NO)),
if(ValueList('Cts','Gms','SP')='SP',sum(aggr(sum( DISTINCT DIA_VALUE_SP),VC_VOUCHER_NO,VC_LABEL_NO))
)))

It is showing only first value, remaining is not showing.

Kindly help to correct this.

Thanks.

[rwunderlich]

On the chart presentation pane, uncheck "Suppress Zero Values" to see if those rows are being calculated as zero.

-Rob