7 Replies Latest reply: Feb 19, 2014 4:05 AM by Ossi Venäläinen RSS

    How to calculate a rolling total in script when multiple dimensions in data

      I cannot figure out how to calculate rolling sum in script..

       

      Found a solution at the discussion board for data with just time dimension and amount but I get confused when there are other dimensions.

       

      ProductPeriodVersionAmountRolling 3
      A1Actual1010
      A2Actual1020
      A3Actual1030
      A4Actual1030
      A1Budget1111
      A2Budget1122
      A3Budget1133
      A4Budget1133
      A5Budget1133
      B1Actual2020
      B2Actual2040
      B3Actual2060
      B4Actual2060

       

      Any hint would be highly appreciated on how to calculate this Rolling 3 column in script when the source data does not contain it.

       

      Cannot attach files here, don't know why.-