268 votes25 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.Anonymous supported this idea ·
An error occurred while saving the commentAnonymous 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!