Pivot Table Calculated Field

[canthony24]

I have a question about calculated fields in a pivot table. In my data set I had to designate fiscal year periods as "This Year" & "Last Year" in another column to get a year over year comparison. Our database has some issues with YOY comparisons since our fiscal years are different from calendar years.

Here is a snapshot of the pivot:
[TABLE="width: 461"]
<colgroup><col><col><col span="2"><col span="2"></colgroup><tbody>[TR]
[TD]Cs[/TD]
[TD][/TD]
[TD]Sales[/TD]
[TD][/TD]
[TD]GP[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]This Year[/TD]
[TD]Last Year[/TD]
[TD]This Year[/TD]
[TD]Last Year[/TD]
[TD]This Year[/TD]
[TD]Last Year[/TD]
[/TR]
[TR]
[TD]63,566[/TD]
[TD]56,751[/TD]
[TD]$2,648,429[/TD]
[TD]$2,278,421[/TD]
[TD]$242,118[/TD]
[TD]$193,956[/TD]
[/TR]
[TR]
[TD]36,204[/TD]
[TD]33,761[/TD]
[TD]$1,605,721[/TD]
[TD]$1,455,193[/TD]
[TD]$165,897[/TD]
[TD]$151,981[/TD]
[/TR]
[TR]
[TD]5,787[/TD]
[TD]5,424[/TD]
[TD]$257,196[/TD]
[TD]$249,473[/TD]
[TD]$24,228[/TD]
[TD]$29,462[/TD]
[/TR]
[TR]
[TD]32,358[/TD]
[TD]33,319[/TD]
[TD]$1,748,081[/TD]
[TD]$1,757,344[/TD]
[TD]$440,030[/TD]
[TD]$423,717[/TD]
[/TR]
</tbody>[/TABLE]

Is there a way to now add in a calculated field to get the difference in "This Year" "Last Year" fields? I'm doing the difference off to the outside of the pivot table but I want it to be inside.

Ideas?