I have a pivot table with Sales figures against a corresponding year.
Ynum Year Sales
Y1 2000 9876896
Y2 2001 9069876
Y3 2002 6986986
Need to calculate
I need to calculate a year on year evolution. The problem is that adding an expression to the pivot table only ads vertical columns, which doesnt let me use the ABOVE() function to calculate the relative percentage with regard to the previous year.
Indeed this is what I tried, but adding this calculation Sum(Sales)/Above(Sum(Sales)) to the expression ads a column after the sales column and not as a row below years. And so it is not calculating correctly the ABOVE().