5 Replies Latest reply: Apr 24, 2012 4:11 AM by Abhinav Agarwal RSS

    Relative percentage in a pivot table

    Abhinav Agarwal



      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.


      Any ideas?


      Thanks in advance,