Getting the right percent when using a Pivot Table.

[AnthoHead]

I am currently looking to calculate a savings percentage. To do this, I have created a pivot table that adds

Column A- All of Company A’s billed costs.
Column 2- All of Company A’s reviewed cost savings

Basically, there is a review process and column two has what we were able to reduce based on our contracted rates. In column 3, I would like it to give me the total calculated savings, but I can’t seem to figure out how to do this. In the raw data, I added a column that calculates this savings per row, but if I add that to the pivot it just averages or sums the total percent found within that column- which is not the total of column A divided by the total of Column B

Is there a way, without me just adding another column and writing in the formula, to have the pivot properly calculate what I’m looking for?

 

[Alex Blakenburg]

See if this is what you are after.
In the menu it was PivotTableAnalyze > Fields,Items & Sets > Calculated Field...