Question: can pivot table do weighted average?
Answer: To calculate the weighted average of a data with a Pivot Table, we can add a column to our source data as an intermediate calculation. This is because Excel doesn't provide a function in the Pivot Table that automatically calculates the weighted average.