Hi. Is there a way to summarize a field using MEDIAN? It's not one of the options.
R Rosie Sep 25, 2008 #1 Hi. Is there a way to summarize a field using MEDIAN? It's not one of the options.
C Charles Williams Sep 25, 2008 #2 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
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
R Roger Govier Sep 25, 2008 #3 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.
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.
A Ashish Mathur Sep 26, 2008 #4 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
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
