Generate DATA and grouped PROGRESSIVE TOTAL in script.

Wed, 11 Jun 2014 11:18:28 GMT

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:

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:

MonthName	CustomerID	MonthSum	ProgrTotal
jan 2014	1	150	150
feb 2014	1	120	270
mar 2014	1	0	270
jan 2014	2	180	180
feb 2014	2	0	180
mar 2014	2	140	320
jan 2014	3	0	0
feb 2014	3	120	120
mar 2014	3	0	120

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)

Re: Generate DATA and grouped PROGRESSIVE TOTAL in script.

Gysbert_Wassenaar — Wed, 11 Jun 2014 11:44:20 GMT

See attached qvw.

Wed, 11 Jun 2014 13:05:55 GMT

Genius!! You helped me a lot!