Is there any way to calculate a weighted average of data in a field as part of the pivot table function? The only alternative I find is a simple average calculation, but I would like to calculate the weighted average of the data in a field based on the data in another field. Specifically, I have a table that accumulates data regarding commissions paid, sales amount and income generated by each sale. The table includes the sales amount and the income earned on each sale, as well as other data. The pivot table I created shows the average of the income earned as a percentage of sales. However, each sale is different and a simple average calculation does not give me an accurate picture of the overall percent of income to sales.

Thanks for your help.