Loading a new column with another column

[yoganantha321]

Hi  all,

I have a data set as like below:

Year	Sale
2014	10000
2015	15000
2016	20000
2017	30000

But I need a new column as like below:

Year	Sale	Previous Year Sale
2014	10000	0
2015	15000	10000
2016	20000	15000
2017	30000	20000

can anybody help in this!!!

Regards,

Yoga

[teiswamsler]

Hi Yoganantha

Try this expression

Rangesum( below( Sum( Sales), -1 ) )

Br.
Teis

[syedabik · Accepted solution]

Hi, 

Try this:

Data:
Load * Inline
[
Year, Sale
2014, 10000
2015, 15000
2016, 20000
2017, 30000
];

Left Join
Load Year+1 as Year,
alt(Sale,0) as PreviousYear
Resident Data;