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.

Item	Sales - This Year	Sales - Last Year	% of Sales - This Year	% of Sales Last Year	Pt Difference
A	65	60	65%	60%	+5.0
B	35	40	35%	40%	-5.0
Total	100	100	100%	100%	0

<tbody>
</tbody>

Can this be done in a pivot table?