Median function on Pivot Tables
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
Thanks for the suggestion and the votes. We’ll keep monitoring this so that we can prioritize it along with the other suggestions here.
Steve K [MS Excel]
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.
Would be valuable to have this function to see pwhat the average hides.
Rick Lawrence commented
Yes, the Median function is so important. Please add to Pivot Tables