9 Replies Latest reply on Aug 2, 2016 9:44 AM by Tharushiw Fernando

    Average of a Moving Sum ( Table Calculation)

    Tharushiw Fernando

      Hi,

       

      I need to calculate the overall average of a 12 month moving sum.

      Please see attached data that I have added in an excel doc.

       

      I was able to calculate the moving sum for the last 12 months using a table calculation for each month

       

      • WINDOW_SUM(SUM([SALES]), -11, 0) 

       

      I need to get an average for each year.

       

       

      The table below shows the Moving Sum for each month (last 12 months including current) >>> I need HELP with calculating the average column ( either in the same worksheet or separate)

       

      Year/Month
      JanFebMarApr
      May
      Jun
      Jul
      Aug
      Sep
      Oct
      Nov
      Dec
      Average
      201210664481066448
      20131076993108286910851921088989107459510840031079976107890310693311067264106568210718591077138
      20141071634106734710651851065114107792510792531073949107294610891521100414111066811155791082430
      20151118817112312911228361118798111893211053631100130109853110878241075567106624610527481099076
      201610495921055429105775510628711061556107357310237251054929

       

       

      * Is there a better way to get the moving sum for each month, year using an LOD calculation?

       

       

      Appreciate the Help.

      Thanks!