Include Median in Pivot Table Value Field Settings
Current summarization options include count, sum, average, min, max, etc., but median is not available.
Thanks for opening this item, looking forward to getting more votes from the community to boost the priority of getting this done.
ash [MS XL]
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).
It would be nice to add also Qurtiles 1st and 3rd.
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.
PLEASE ADD MEDIAN TO PIVOT TABLE ASAP. Very inconvenient that it is not included.
YES PLEASE! How is it possible that Google Sheets has this capability but Excel which is much more powerful does not?
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 = AGGREGATE
Or use Mourad Louhas Excel-translater.de ;-)
This is key for our work, having not just MEDIAN but a percentile function working on Pivot Tables is a long time waiting feature for us.
hi aikimark1955, it's just a matter of prioritizing what we work on, so getting votes on this item is actually helping us weigh the importance vs. other items..
It is a step in the right direction. Why isn't it "possible" with pivot tables?
While it's not possible in Pivot Table value fields settings today, Excel 2016 introduced a new MEDIAN function in DAX. Does this help?
I have been waiting for this for years but Microsoft doesn't seem to care.