Rolling sum from the same column

[hakim_ez]

Hi All,

I have one column A in my table A, the value saved are the sum of different series and I want to create a new column Cwho add the max from the previous series to the new series. The name of the series can be joined from another table B. The len of values depend of time windows ( Table A column B)

Example :

Table A column A (VALUES): 0,12,15,30, 0,2,4,5 ... 

Table A column B : time

Table B column C(Name of series) : A, B

Table A new column C : 0 ,12 ,15 ,30, 30, 32 ,36 ,41

Thanks