|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 25th, 2008, 04:14 PM
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
September 25th, 2008, 04:46 PM
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
September 25th, 2008, 05:24 PM
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
September 26th, 2008, 01:56 AM
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
