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


Can this be done in a pivot table?