Calculated Field - Pivot Table with 2 xlPercentOfColumn Fields

[gmooney]

I have a pivot table that is showing sales for some rows as well as the % of total sales for those same rows.

I do this for this year and last year time frames.

I want to be able to have a calculated field that show what the point difference is between a row's this year percent of total against last year's % of total.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Item[/TD]
[TD]Sales - This Year[/TD]
[TD]Sales - Last Year[/TD]
[TD]% of Sales - This Year[/TD]
[TD]% of Sales Last Year[/TD]
[TD]Pt Difference[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]65[/TD]
[TD]60[/TD]
[TD]65%[/TD]
[TD]60%[/TD]
[TD]+5.0[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]35[/TD]
[TD]40[/TD]
[TD]35%[/TD]
[TD]40%[/TD]
[TD]-5.0[/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD]100%[/TD]
[TD]100%[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]


Can this be done in a pivot table?