Pivot table totals row and calculated columns - total not calculated correctly

[phbryan]

Hello,

In the attached spreadsheet, the totals of one of my calculated columns, Average of Prod % Reached,
is not correct. The spreadsheet has a description of the issue and where, I appreciate any help!

[rorya]

You'll need to use the data model (Power Pivot) so that you can use measures, not calculated fields. Calculated fields always sum any field that you refer to before they do anything else.