Tag: sumproduct within a pivot table
Calculate weighted average in Excel PivotTable in 2 ways
Here are a few methods on how to calculate the weighted average in Excel PivotTable or DAX. It is not so simple as a weighted average by using calculation in an Excel worksheet. The good news is that you can use that method to validate your results.