259 votes24 comments · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
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.Neil Garrett supported this idea ·
An error occurred while saving the commentNeil 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.