Median value within a pivot table
 

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

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

Median value within a pivot table
 

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

"Dominic" wrote:

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

Median value within a pivot table
 

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

Write back if you have any problems with the formulas.

"Bee" wrote:

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

"Dominic" wrote:

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