View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mischa Mischa is offline
external usenet poster
 
Posts: 1
Default Weighted Average in Pivot table

Hi all,

just ran into a problem after looking at the average of a pivot table and
finding the result not logical. Is it possible to do a weighted average
calculation in a pivot table? It currently takes the average of all the
averages and it obviously doesn't make any sense.

thanks in advance,
mischa