View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dominic
 
Posts: n/a
Default Median value within a pivot table

Hi Bee,

Pivot Tables do not support the Median function.

You could probably find the median via formulas and display it next to the
pivot table.

HTH

"Bee" wrote:

Hi, I am trying to obtain the median value within a list of data alongside
Average, Max and Min values. I have tried setting this up as a calculated
field but it does seems to work and instead gives me the sum of that field.
Is this possible?
Thanks