2 Replies Latest reply: Mar 30, 2016 9:11 AM by Mohamed Ahid RSS

    Use dimension total in expression

    Matt Maino

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

       

      CategoryWeighted Interest RateOutstanding Balance
      14.89$523,467.90
      23.55$1,567,896.89
      34.37$456,134.45
      45.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