Add weighted average as a calculation option in the pivot table report. Current options are sum, average, min, max.