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

    Relative percentage in a pivot table

    Abhinav Agarwal

      Hello,

       

      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

      Y2/Y1

      Y3/Y2

      ...

       

      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,

      Regards