2 Replies Latest reply: Jul 21, 2017 5:54 AM by Milind Deshmukh RSS

    cumulative with Max of Date

    scotly victor

      This is my data

      Input

      Date, store ,amount

      1/6/2017,AAA,30

      4/6/2017,AAA,40

      19/6/2017,AAA,30

      1/6/2017,BBB,30

      4/6/2017,BBB,40

      1/6/2017,CCC,20

      4/6/2017,CCC,40

      19/6/2017,CCC,30


      Desired Output in front end

      Date, store ,amount

      19/6/2017,AAA,100

      4/6/2017,BBB,70

      19/6/2017,CCC,90