2 Replies Latest reply: Apr 23, 2013 6:52 AM by jagan mohan rao appala RSS

    How to get previous value on straight table?

    Leandro Duarte

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

       

      Basically here is the table example:

       

      PeriodValueExpected value
      Jan-12100
      Feb-12200100Value of January
      Mar-12300200
      Apr-12400300
      May-12200400
      Jun-12100200
      Jul-12100100
      Aug-1290100

       

      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