Aggregation issue Pivot table

[manish_kumar]

Hi

I am getting some issue in doing Aggregation in expression.

My dimension is a calculated dimension but when I am aggregating it in the Expression I am not able to reduce the aggr field.

Please fine the attached excle file having the desired output and QV app for the code.

[bhaveshp90]

Hello, Please explain what you are trying to get here? Is it Column H from the Excel, you are trying to get the expression for?

[manish_kumar]

‌Hi

I want 5.26% in the yield column against total row..

[sunny_talwar · Accepted solution]

Do you need this in a text box object? Try this

=Num(Sum(Aggr(Sum({<Duration={'<=1'}>}[Amortised Book Value])*sum([AWAC Yield]), Category, [Company Name], [Security Name], [Maturity Date], Month))/Sum({<Duration={'<=1'}>}[Amortised Book Value]), '#.##%')

[manish_kumar]

I need that in table subtotal only. But your expression had worked for me in that also.

Thanks for help...