Previous data

[kicchu465]

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

[sunny_talwar]

You want this in a chart or script?

[el_aprendiz111]

Hi,

1 option

LOAD *, PEEK(sales)+sales AS Newcolumn;
LOAD * Inline
[
Name,sales
aa,100
bb,200
cc,300
dd,400
];

[kicchu465]

Hi Fer,

Thanks for the reply.

Its working fine now.

much appreciated for the video provided.

Thanks,

Kb

[its_anandrjs]

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

];