2 Replies Latest reply: Mar 2, 2015 3:39 AM by Jonathan Dienst RSS

    Weighted age per year

    Susanne Jacobsson

      Hi all,

       

      I need to get weighted age per year in a straight table. I have tried a lot of ways but I do not get the weighted age per year (my dimension), only the total weighted age for my data. I hope that someone can help me to bring some light over my problem.

       

      Dimension:

      Year

       

      Fields:

      Age

      WEIGHT

       

      Sum(Total Age * Aggr(Sum(WEIGHT), Age)) / Sum(Total Aggr(Sum(WEIGHT), Age))

       

      Thanks a lot in advance!

       

      Best,

      Sussi