First problem is that the way you have totalled "sales per unit " in your pivot tables doesn't make sense

Sales per unit in your source data below is sales ($) / units.

KeyProductUnitsSalesSales per/unitActuals Wand A 10 50 5 Actuals Wand A 12 66 5.5 Actuals Wand A 67 300 4.48 Budget Wand A 67 321 4.79 Budget Wand A 100 550 5.5

In the pivot table use a calculated field to work out "total of all sales for wanda" / "total units for wand a"

(actual sales of 416 , 89 units is 416/89 = 4.67 not 15 as in your original pivot table)

calculated field = =Sales /Units

Row Labels Sum of Units Sum of Sales sales per unit Sum of Units Sum of Sales sales per unit Wand A 89 416 4.67 167 871 5.22

Once you fix that up will move onto your original question

## Like this thread? Share it with others