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

[Anonymous]

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

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

[swuehl · Accepted solution]

You may probably want to look into the other chart inter record functions, like before() and in your case, after().

(or above() and below() for looking one row above or below).

Hope this helps,

Stefan

[Anonymous]

thx, forgot those functions completely!!