Pivot Table Fields: Median function?
Hi. Is there a way to summarize a field using MEDIAN? It's not one of the
options. |
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. |
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. |
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. |
All times are GMT +1. The time now is 02:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com