Get Previous in current

[#1]

Hi,

Can you please help to fix this issue :

I need to get the previous value of each field and show it instead of the current one example:

Year      Sales

2010     10

2011     25

2012     560

2013     58

What i want to get is :

Year      Sales

2010     0

2011     10

2012     25

2013     560

Is it possible with qlikview ? Can you help please?

Thanks

[#2]

If this is a pivot table use the Above() function or Sum({$<Year={$(=Max(Year)-1)}>} Sales)

[#3]

Hi,

Thanks for your response but It doesn't work ... please see attached qvw.

[#4]

Attached