3 Replies Latest reply: Feb 26, 2018 12:47 AM by Pat Felicita RSS

    Difference between columns in a pivot table

    Abhinav Agarwal



      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.