Include Median in Pivot Table Value Field Settings
Current summarization options include count, sum, average, min, max, etc., but median is not available.
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.
This is key for our work, having not just MEDIAN but a percentile function working on Pivot Tables is a long time waiting feature for us.
hi aikimark1955, it's just a matter of prioritizing what we work on, so getting votes on this item is actually helping us weigh the importance vs. other items..
It is a step in the right direction. Why isn't it "possible" with pivot tables?
While it's not possible in Pivot Table value fields settings today, Excel 2016 introduced a new MEDIAN function in DAX. Does this help?
I have been waiting for this for years but Microsoft doesn't seem to care.