Weighted Average in Pivot table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Mischa said:
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
Click to expand...

nope - pivot tables are quite simple in the calculations they will
allow you to do. You can't do a weighted average. You could do it
'manually' by displaying the value to average along side the weighting
in the pivot table and then put a formula in a column next to the pivot
table and calculate the average of that.
 
Back
Top