Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a data like below
Name,sales
aa,100
bb,200
cc,300
dd,400
here I want output like
Newcolumn
300 [100+200]
500
700
how can I achieve this?
Thanks
You want this in a chart or script?
Hi,
1 option
LOAD *, PEEK(sales)+sales AS Newcolumn;
LOAD * Inline
[
Name,sales
aa,100
bb,200
cc,300
dd,400
];
Hi Fer,
Thanks for the reply.
Its working fine now.
much appreciated for the video provided.
Thanks,
Kb
You can do the same with RangeSum()
LOAD *,RangeSum( Previous(Sales)+Sales ) as NewCol;
LOAD * Inline
[
Name,Sales
aa,100
bb,200
cc,300
dd,400
];