Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have table data:
Date Value MonthName
10.02.2017 13 feb 2017
15.02.2017 11 feb 2017
09.05.2017 21 may 2017
LOAD
Date,
Value,
MonthName
Resident SQL_Table
I need to get aggregated cumulative SUM for each monthName, like this:
MonthName CumulativeSUM
feb 2017 24 //for all months before March
may 2017 45 // for all months before June
How can I reLOAD in order to get such data?
Thank you in advance!!
P.S.:sorry for third topic within the day
The final table won't have Date? just MonthName and CumulativeSUM?
There is another field - Source_Type (like Cars, Aircrafts, Boats etc)
But the final table won't have Date, right? Accumulation is for Each Source_Type and restarts when Source_Type changes?
Yes, sure. No particular dates (like 14.06.2017), but only monthnames
