1 Reply Latest reply on Feb 28, 2016 2:14 PM by Gianni Ceresa

    Calculation based on 2 columns in a pivot table

    bjbreitling

      I have a pivot table that has company on the vertical axis and account on the horizontal on the top like below:

       

      company  Income Gallons

      comp1      630       4

      comp2      588       7

       

      I want to create an additional column that divides income by gallon. Can I have some help? I know there is a similar question in the discussion forum but I don't know what is meant by "column area" so some moderately detailed instructions on where to navigate to do this would be appreciated by this newbie.

       

      Thanks!