3 Replies Latest reply: Aug 27, 2013 12:57 PM by Gysbert Wassenaar RSS

    Calculating a group of dates in same field

      All ...

      Here is the problem:

       

      I need to either create a load script or an expression that perform a continuous rollup of data where each ID would have a show the accumulated amount month over month.  Eventually, the data will be visualized.  Any help is appreciated.

       

      Source Data

      IDYearMonthAmount
      A20102010010
      A201020100228
      A201020100331
      B20102010015
      A20102010043

       

       

      Expected Result

      IDYearMonthAmount
      A20102010010
      A201020100228
      A201020100359
      B20102010015
      A201020100462