Pivot Calculated Field Problem

Hello,

Does anyone know how to create a Calculated Field within a pivot table based upon the difference between values within a single field?

I have included a graphic that shows the field, called "Type" with two values: "Actual" and "BUDGET_INPUT."

I am trying to see how far I am under or over budget by introducing the formula (Actual-Budget)/Budget as a calculated field. However, I have not determined how to do this.

I have created a basic formula in a column called "PCT" which has the desired output for reference.

Excel Pivot Problem.jpg

Can anyone offer assistance?

Thanks,
B Glass

Pepe,

No problem. I have attached a sample sheet for reference.

Thanks so much,
B