2 Replies Latest reply: Jan 24, 2012 7:39 AM by Anita Fuchten RSS

    expression between previous and current Year . . . should I use Last() ??

    Anita Fuchten

      I have a pivot table containing 1 expression which contains a number of transactions.

      Now I want to create a second expression (last) which contains a percentage with the difference between the current number of transactions with the previous number of transactions

       

      e.g. the number of transactions of year 2011 - 2010 / 2010 - 2009 / 2009 - 2008

       

      TEST.png

      I did try some stuff with the function Last() but this needs a fixed offset ... is there a way of using this function and take the previous value??

       

       

      thx in advance!!

       

      Anita