I need output based on my below requirement

[venkatbza]

Hi,

i have YEAR  and SALES columns  i need output like below table.

any one help how can i do

year	sales	output
2011	100	100
2012	200	300
2013	300	600

Regards,

Venkat

[Gysbert_Wassenaar · Accepted solution]

load year, sales, rangesum(sales, peek('output')) as output from ...somewhere...;

[venkatbza]

Thank you somuch Gysbert Wassenaar

[its_anandrjs]

Hi Venkat,

Another way of the same is

A:
LOAD year,sales,output,

if(RowNo()=1,sales,sales+Peek('Accumulate'))  as Accumulate;
LOAD * Inline   [
year, sales, output
2011, 100, 100
2012, 200, 300
2013, 300, 600  ];

Regards

Anand

[venkatbza]

Thank you somuch