Access Data in Previous Row - Straight Table

[#1]

Hi all,

I'd like to create a year-over-year variance calculation. I have a table with yearly spend and spend per resource. I'd like to calculate the variance of the current year's spend per resource ("Per Atty" below) to the previous year's. I think I can do this with use of the TOTAL function and a set analysis expression, but is there an easy way just to access the data from an adjacent row?

[#2]

did you explore chart inter record functions?

[SunilChauhan · Accepted solution]

Use above() function

above(Spend)

hope this helps

[#4]

Thanks!