4 Replies Latest reply: Nov 8, 2018 6:09 PM by Sumanth Gopi RSS

    How can you calculate the variance of two columns in a pivot table?

    Sumanth Gopi

      Hi,

       

      I have created a pivot table which has values as the rows and the financial year (FY18, FY19, etc) as the columns. I have calculated the different values as shown in the attachment. I am trying to insert a variance column after the FY19 column that calculates the variance between FY18 and FY19. Does anybody know how I can do that?

       

      Any help on this would be much appreciated!

       

      Regards,

      Sumanth