Cummulitive sums

[sculptorlv]

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

[sunny_talwar]

The final table won't have Date? just MonthName and CumulativeSUM?

[sculptorlv]

There is another field - Source_Type (like Cars, Aircrafts, Boats etc)

[sunny_talwar]

But the final table won't have Date, right? Accumulation is for Each Source_Type and restarts when Source_Type changes?

[sculptorlv]

Yes, sure. No particular dates (like 14.06.2017), but only monthnames