Feedback by UserVoice

 

Neil Garrett

← Welcome to Excel’s Suggestion Box!

My feedback

  1. Include Median in Pivot Table Value Field Settings

    259 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    24 comments  ·  Excel for Windows (Desktop Application) » PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
    Accepting Votes  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

    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

(thinking…)