please help with showing subtotal averages in a pivot table

[flex33]

I have a pivot table that calculates item level error and accuracy.

I use a Calculated Field which calculates percentages from Actuals vs Forecasted.

The subtotal auto-calculates in the same manner. But this is not wanted.

I want to see the AVERAGE of the percentages in col D and col E (as auto-calculated subtotal)

 

[Alex Blakenburg]

This comes up regularly.
What you are trying to do is take and average of an average. This is mathmatically not correct.
See @RoryA 's comment here
average in pivot table doesn't match
Or see article here:
Taking an Average of Averages – Why it’s Wrong

 

[flex33]

Thank you Alex!

 

[Alex Blakenburg]

Thanks for the feedback, glad we could help.