Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I think it should be possible. What is the expected output based on your provided sample?
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 .