This content has been marked as final. Show 2 replies
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|
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?