compare value of year N and year N-1

[#1]

Hello,

I need to have two colomns where in each lines i have the value of year N (in first field) and year N-1 (in second field).

For a better understanding here is an exemple:

Year	Net Year N	Net Year N-1
2013	9
2014	14	9
2015	10	14
2016	17	10
2017	25	17

I used the following expression:

Sum({<Year={"$(=(Year(AddYears(Date('01/01/'& Year),-1))))"}>}TOTAL  [Net])

But the problem is that it work only when i select value in colmn "year"

thank you.

[sunny_talwar]

Try these two expression

Net Year N

Sum(Net)

Net Year N-1

Above(Sum({<Year>} Net)) * Avg(1)

[sunny_talwar]

Or use The As-Of Table