Use dimension total in expression

[#1]

I need to calculate a weighted average in a pivot table for each collapsed dimension value. Something like this:

Category	Weighted Interest Rate	Outstanding Balance
1	4.89	$523,467.90
2	3.55	$1,567,896.89
3	4.37	$456,134.45
4	5.03	$2,456,743.84

In order to do this I will need an expression that looks like this:

Interest rate of individual loan / sum of all loan outstanding balances in category

Is it possible to do this in an expression or will I need to do it in the load script?

Thanks

[sunny_talwar]

I think it should be possible. What is the expected output based on your provided sample?

[mohamed_ahid]

try to do it with an Aggr(Interest rate of individual loan / sum of all loan outstanding balances in category  ,Category) function it will works .

the best way is to do it while loading of corse .