Include Median in Pivot Table Value Field Settings
Current summarization options include count, sum, average, min, max, etc., but median is not available.

We’ve just merged two items that were both requests for the Median function in PivotTables. One had been for Windows, the other for Mac. When we get to this, we should actually make the addition on all platforms including Windows, Mac, Web, and others.
25 comments
-
Yazan Hlayel commented
It would even be better to get PERCENTILE functions as it covers more than just MEDIAN.
There's a list of functions that can improve the usability of pivot tables in Data Science such as QUARTILE & IQR. -
Dalton commented
For the love of God add this, it's 2019. Google Sheets has it, it's a better measure than average, and it takes way too **** long to work around it.
-
Alan Moorse commented
The Median function is absolutely needed in pivot tables. Without it there, the user is left with complex, slow, unwieldy work-arounds.
-
Neil Garrett commented
The Medium is used as standard average across the public sector in the UK. Sometimes it is used alongside the mean to demonstrate the variance of individual data on the whole. An example would be the Gender Pay Legislation which requires large employers in both the public and private sector in the UK to produce data on gender pay gaps. Often one high paid male employee could be an outlier that has a dramatic impact on the average. Working medians outside of pivot tables is long-winded, especially if you are tasks with continually reviewing smaller datasets and cutting the data in various ways.
-
Bill Long commented
Also need stdif, stdifs, maxif, maxifs, minif, minifs functions.
-
Anonymous commented
Would be valuable to have this function to see pwhat the average hides.
-
Rose Becerra commented
I would love to see this feature in Pivot Tables in Excel. It's so valuable when looking at data that doesn't follow a nice bell curve and the mean and median give very different stories.
-
Bill Jelen commented
During a recent Power Excel seminar, I accidentally discovered that Median in a pivot table is quite easy if you choose Add This Data to the Data Model whilst creating the pivot table: https://www.youtube.com/edit?o=U&video_id=VivKErLgwmk
-
Aaron Caffrey commented
All measures of central tendency are required for Excel to be fit for purpose in 2018 and beyond. How can this not be the top priority for Excel - a statistics application, that doesn't support basic statistics?
-
Aaron Caffrey commented
While you're at it, please add Mode, Mid, Mid-Range, MAD (all types of mad - for median, mode, mean, etc).
-
Rick Lawrence commented
Yes, the Median function is so important. Please add to Pivot Tables
-
Kasia commented
It would be nice to add also Qurtiles 1st and 3rd.
-
Anonymous commented
Excel pivot tables are great for quick data analysis. However, if you have data that figures some non-representative outliers the average is not suited as estimator of the sample mean. The median is a robust estimator of the mean in these cases.
So it would add great value to the pivot table functionality if you included the median in the summarization options. Please go for it!
-
Tim Potter commented
Medians would be great - but why stop there? The ability to show quartiles or indeed any percentile value would be really useful please, particularly if it could work as a filter (i.e. exclude values below P1 and above P99).
-
Josh Berris commented
Come on MS. It is crazy that this is not available. It is also bad for businesses everywhere who are making decisions based on "means" when they should be using "median". Get it done ASAP.
-
Elysia commented
PLEASE ADD MEDIAN TO PIVOT TABLE ASAP. Very inconvenient that it is not included.
-
Anonymous commented
YES PLEASE! How is it possible that Google Sheets has this capability but Excel which is much more powerful does not?
-
Anonymous commented
Please add a median function for Pivot Tables. It is mind boggling how Google Sheets has this capabilities but the much more powerful MS Excel does not
-
Anonymous commented
As Excel is such a mature application, it is frankly a bit absurd that median isn't available in the Pivot Table value fields settings.
-
Andreas Thehos commented
Hi, you have to calculated Median beside your PivotTable. You can see a workaround on this German page: http://thehosblog.com/2013/08/02/excel-median-fur-pivot-tabellen/
WENN = IF
AGGREGAT = AGGREGATEOr use Mourad Louhas Excel-translater.de ;-)
Good luck
Andreas