Pivot Table help
 

How do I calculate weighted averages in Pivot tables? Say I have a
column containing total sales for the region and a column containing
some other piece of information which I want to find the weighted
average of with respect to total sales. How do I calculate that on a
per-region basis?

I want region as a row header, avg widgets as a column header, and
weighted average widgets (by sales) as the values. Is this possible?