| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Fields: Median function?
Hi. Is there a way to summarize a field using MEDIAN? It's not one of the
options. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pivot Table Fields: Median function?
Hi Rosie,
No, unfortunately there is no way of using MEDIAN inside a pivot table. regards Charles __________________________________________________ The Excel Calculation Site http://www.decisionmodels.com "Rosie" wrote in message ... Hi. Is there a way to summarize a field using MEDIAN? It's not one of the options. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pivot Table Fields: Median function?
Hi Rosie
there is no median function within the PT, only Average. You could have a column outside your PT in which you sued the formula =MEDIAN(SourceTable_Column) inserting the correct references for the source. -- Regards Roger Govier "Rosie" wrote in message ... Hi. Is there a way to summarize a field using MEDIAN? It's not one of the options. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pivot Table Fields: Median function?
Hi,
I have not tried this but can you use the median formula in the Calculated filed formula -- Regards, Ashsih Mathur Microsoft Excel MVP www.ashishmathur.com "Rosie" wrote in message ... Hi. Is there a way to summarize a field using MEDIAN? It's not one of the options. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Median value within a pivot table | Excel Discussion (Misc queries) | |||
| Can I use IF function in calculated fields in a pivot table? | Excel Worksheet Functions | |||
| How can I put the median on a pivot table? | Excel Worksheet Functions | |||
| Median in pivot table | Excel Discussion (Misc queries) | |||
| Excel's Pivot Table & Subtotal function should have a median fie. | Excel Worksheet Functions | |||
Linear Mode
