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!

Gianni Ceresa

Hi,

Try to avoid double posting: Calculation on two columns in pivot table

People reading Business Intelligence also read Business Intelligence Suite Enterprise Edition, so double posting is a great way to leave forever open threads ....