Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
thx, forgot those functions completely!!