Calculated Field

[Jimmytinfoil]

Good Evening

Im looking for some advice on a calculated field. Ive made a sample spreadsheet like so

Source Data is underlined in RED
Pivot Table is underlined in Green
Difference is a manual formula that I added
XLS is here

Question:- Is there a way to create a calculated field rather than me entering a formula outside the Pivot Table?

Pivot

 

[RoryA]

With a regular pivot table (as opposed to power pivot) you want a calculated item, not a calculated field since you want the difference between two items in the same column in the source data.

 

[Jimmytinfoil]

Thanks Rory - All sorted now.