Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
load year, sales, rangesum(sales, peek('output')) as output from ...somewhere...;
load year, sales, rangesum(sales, peek('output')) as output from ...somewhere...;
Thank you somuch Gysbert Wassenaar
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
Thank you somuch