Pivot Table - using the Average on a field but not including maximum value

[LoraineB08]

Hi,
I have a created a pivot table that shows the duration of run times. I am doing an average on the duration but want to remove the maximum value from the average as there are valid reasons for the run time to extremely longer than the remaining duration run times. How do I eliminate the max value from being included in the average?
Thank you for any info you can provide.
Loraine

 

[pkdeimos]

Hi,

I am not sure if I got your question right. But will give it a try. The below will work irrespective of range is in pivot table or otherwise

Average excluding max value = (Sum(Range)-Max(Range))/(Count(Range)-1)

Regards