Feedback by UserVoice

Neil Garrett

My feedback

  1. 268 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    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 comment
    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.

Feedback and Knowledge Base