Pivot table calculated dimension

[suresh_qv50]

Hi Every one,

I was create a pivot table, Created drill down group as QMDDrill, this is 1st dimension.  2nd dimension is calculated condition based on group .

i wrote as

=if(GetCurrentField(QMDDrill)='Quarter',num(aggr(sum(DueAmt),Quarter),'$#,##0.;($#,##0.00)'),

if(GetCurrentField(QMDDrill)='Month',num(aggr(sum(DueAmt),Month),'$#,##0.;($#,##0.00)'),

if(GetCurrentField(QMDDrill)='Duedate',num(aggr(sum(DueAmt),Duedate),'$#,##0.;($#,##0.00)'),)))

this was working fine but Getting wrong result. Can any one give alternate solution for this

Thanks in Advance

[swuehl]

Could you elaborate further on what numbers you expect to see and what you get.

Best by uploading a small sample QVW and your requested results.

[sunny_talwar]

Not sure what you mean when you say wrong result. May be if you can provide a sample with your expected output, we are able to help better.