Feedback by UserVoice

Anonymous

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.

    Anonymous supported this idea  · 
    An error occurred while saving the comment
    Anonymous commented  · 

    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!

Feedback and Knowledge Base