Create new column cumulated

[#1]

Hi to all, anybody knows how to create a new cumulated column ?

I tried to explain I have day stock and I want to create a new column that is the total stock as algebric sum

Date	Day Stock	TOTAL Stock	How to calulate
01/01/2010	1	1
02/01/2010	2	3	= today stock + prevous stock
03/01/2010	3	6	= today stock + prevous stock
04/01/2010	4	10	= today stock + prevous stock
05/01/2010	-1	9	= today stock + prevous stock

If I select 4/1/2010 I want to see day stock = 4 Total Stock = 10

Thanks
Andrea

[Oleg_Troyansky]

Andrea,

if you want to perform this calculation in the load script look at functions "PEEK" and "PREVIOUS".

If you want to perform this in a chart, look at the "Accumulation" option for Chart Expressions, or at functions "Above" and "Before"