Pivot Table Mode Function
 

Hi

I have generated a pivot table using data from an Access Query. I'm able to generate an Average column in my pivot table but want to be able to calculate a mode. I haven't found this option within the pivot table and was hoping someone could point me in the right direction or explain how to generate this.

Many thanks - David