2 Replies Latest reply: Sep 17, 2013 9:00 AM by Abhinav Agarwal RSS

    Difference between columns in a pivot table

    Abhinav Agarwal

      Hello,

       

      I have a pivot table, with the Year in columns. I have 2 measures for each year. How can i have a third column to display the difference between the measures in these two years.

                       2012               2013              Difference

                     Sales, profit     Sales, profit       Sales%, profit%

      Product A  300    25         350    75            ??           ??

      Product B  .................

      Product C

       

      Find attached a sample application.

       

      Thank you in advance for some possible solutions.