View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
suechndlr suechndlr is offline
external usenet poster
 
Posts: 1
Default 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?