ExcelBanter - weighted average in pivot excel 2007

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - weighted average in pivot excel 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/198935-weighted-average-pivot-excel-2007-a.html)

mohavv

weighted average in pivot excel 2007

Hi,

Is there a way of getting a weighted average in a pivot table (Excel
2007)?

I've got following Quantity in column A, Price in column B, Return in
column C

I want to display the weighted average of Price in a pivot.

Cheers,

Harold

Herbert Seidenberg

weighted average in pivot excel 2007

Add helper column to source data:
http://www.savefile.com/files/1731427

All times are GMT +1. The time now is 09:17 PM.