Calculated Field - Pivot Table with 2 xlPercentOfColumn Fields

gmooney

Board Regular
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.

ItemSales - This YearSales - Last Year% of Sales - This Year% of Sales Last YearPt Difference
A656065%60%+5.0
B354035%40%-5.0
Total100100100%100%0

<tbody>
</tbody>


Can this be done in a pivot table?
 

Some videos you may like

This Week's Hot Topics

Top