How do I calculate a weighted average in a pivot table?
 

I have Product Code, Balance, Rate and Office#. My pivot table sums Balance
by Product Code (rows) and Office (columns). What would be the pivot table
formula to also calculate the average rate, weighted by balance?