Pivot Tables - Calculated Fields - Weighted Averages
Posted on 2013-11-04
How does one create a weighted average in a pivot table?
The AVE function provides a simple average but most of my calculations and reports require weighted averages (Means). Using a column outside and to the right of my Pivot Table is not a good work-around since the number of columns in my data often changes. In the past, this has caused me to lose the data.
Appreciate an answer but please avoid using anything other than built-in formulas as I cannot program using a computer language.
Thanks for your help.