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)
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)