This content has been marked as final. Show 2 replies
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:
MonthName(date) as Month,
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:
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)