Pages

Search

Excel Help Forum - Excel Charting & Pivots: Calculating Weighted Averages in Pivot Tables

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Calculating Weighted Averages in Pivot Tables
Does anyone know the best way to have a pivot table return a weighted average instead of the standard average? Within the attached spreadsheet I have a pivot tab. I'd like to create a weighted average for the APR. Currently it shows 4.62%. On the data tab I calulated the weighted average at...