Median value within a pivot table

B

Bee

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
 
D

Dominic

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
 
B

Bee

Thanks Dominic,
I see there are lots of people trying to do the same thing, yep going to go
down the formulae route now after an hour of frustration trying to get it to
work!!
Thanks for your help
B
 
D

Dominic

Sure. Yeah, it seems to be a pretty popular request.

Write back if you have any problems with the formulas.
 
Top