Calculated Field - Pivot Table with 2 xlPercentOfColumn Fields


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


Can this be done in a pivot table?

Some videos you may like

This Week's Hot Topics