3 Replies Latest reply: Jul 6, 2016 5:24 AM by mahesh kumar RSS

    Cumulative sum

    Paul Wonford

      Hi guys,

       

      I have the following

        

      NamePurchase amountPurchase date
      Bob501/01/2016
      Bob501/10/2016
      Bob1001/02/2016
      Ed201/08/2016
      Sid501/08/2016

       

      Is there any way in my load script i can have a cumulative sum on purchase amount so the table ends up looking like this

       

      NamePurchase amount
      Bob20
      Ed2
      Sid5