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.
An error occurred while saving the commentTim Potter commented
Medians would be great - but why stop there? The ability to show quartiles or indeed any percentile value would be really useful please, particularly if it could work as a filter (i.e. exclude values below P1 and above P99).Tim Potter supported this idea ·