2 Replies Latest reply on Aug 13, 2018 2:56 AM by alexandra price

    LOD - Sum of Avg(monthly value)

    alexandra price

      Hi Guys,

       

      I have a data set in which in below format                                                                                                            so the average of each seems correct in first step

       

      Month aggregate level :

      The dataset has lots of duplicated records (the Value is same for the same year same month), because of this , i can't  sum the value by sum(Value), instead of sum , i use Avg )

       

          

       

      Year aggregate level

      So now come to aggregate Yearly level where

       

      Somehow i would like to create a calculated field where it Sums the average of Month  by Year, for example,  it sums the monthly avg Value, in this case, 100,200,300.....1200 and result 7800.

       

      Wanted Result

       

       

      My Attemp fail :

       

      Any Idea what i should do , please

       

      Thx