Pivot table Expresion group by on only first dimension

[suresh_qv50]

Hello,

I have attached my Qvw,

Please find the attachment and help me that, Pivot table there will be 3 dimension and 2 expression

The 2nd Calculated dimension and the 2nd Expression needs to give same result but here getting mismatches

We need Same due value which is in dimension in Expression(Due) too.

2. Is it possible to make 2nd Expresion is only group by on first dimension ?

Please Reply back ASAP

[sunny_talwar]

Please reduce the size of the application and then reattach

Preparing examples for Upload - Reduction and Data Scrambling

[suresh_qv50]

Sunny The data reduced   please find the attachment .

Thanks&Regards

suresh

[sunny_talwar]

Use this as your calculated dimension:

=Num(Aggr(Sum({<paidindays = {'*'}>}DueAmt),Quarter),'$#,##0')

[suresh_qv50]

Sunny,

Your Expression working fine. I need same Equivalent result Expression in Expressions not in dimensions.

If i use the same expression in  expression it displays null ('-')

If possible please help us with Expression

[sunny_talwar · Accepted solution]

May be this in the expression:

Sum(TOTAL <Quarter> DueAmt)