2 Replies Latest reply on Jan 5, 2017 9:08 AM by Leslie Raillon

    Moving sum but without restart each year

    Leslie Raillon

      Hi all,

       

      I am new to moving sums and I probably am missing something.

       

      I have a simple moving sum on the last 12 month:

      WINDOW_SUM([Number of activations], -11, 0)

       

      And it restarts each year...

       

      Enclosed data

       

      Any idea how to change this?

       

      THanks a lot

       

      Regards

       

      Leslie