How to get previous value on straight table?

[#1]

Hi, I'm trying to get the previous value in a straight table.

Basically here is the table example:

Period	Value	Expected value
Jan-12	100
Feb-12	200	100	Value of January
Mar-12	300	200
Apr-12	400	300
May-12	200	400
Jun-12	100	200
Jul-12	100	100
Aug-12	90	100

I wanted to do it in the chart expression. Attached it is the QV as example

I have tried already the Before function, without sucess.

So, if somebody could help I really appreciate.

Thanks in advance, Leandro

[kaushiknsolanki · Accepted solution]

Hi,

     Try above([ValueCurrent])

     Have a look at the attachment.

Regards,

Kaushik Solanki

[jagan]

Hi,

You can use Above(), to get the value of previous row in a straight table.

Regards,

Jagan.