2 Replies Latest reply: Jun 11, 2014 9:05 AM by Kirill Sadekov RSS

    Generate DATA and grouped PROGRESSIVE TOTAL in script.

      Hi everybody!

      Don't know how to do this and my head is fully broken because of my task.

      There is Sales table like this:

      MonthNameCustomerIDMonthSum

      jan 2014

      1150
      feb 20141120
      jan 20142180
      mar 20142140
      feb 20143120

      Script is simple:

      Tab1:

      LOAD

      MonthName(date) as Month,

      CustomerID,

      round(Sum(Sales)) as MonthSum

      Resident Orders Group By CustomerID, (MonthName(date));

       

      I need table with no-sales-months and with progressive total field, something like this:

       

      MonthNameCustomerIDMonthSumProgrTotal
      jan 20141150150
      feb 20141120270
      mar 201410270
      jan 20142180180
      feb 201420180
      mar 20142140320
      jan 2014300
      feb 20143120120
      mar 201430120

       

      Hope you have more experience and more stable brains instead of me!

      Waiting for your help!!

       

      P. S. I need it in script. I've made the table with progressive total but without no-sales-months)