| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
| pivot table - New Data | Excel Discussion (Misc queries) | |||
| how to delete/clean out the row list in pivot table | Excel Worksheet Functions | |||
| Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
| Pivot Table Problems | Excel Discussion (Misc queries) | |||
Hybrid Mode
