Hi,

I have some huge files I'm working with and only just got my head around pivot tables which has been amazing. The only issue I'm having is I need to get the harmonic mean in one column but I can only see a way to display values as an average which I assume is just normal mean? Is there a way to get a harmonic mean / HARMEAN function in the pivot table?

Thanks
Alex