ExcelBanter - Pivot Table - 50th Percentile instead of Average

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pivot Table - 50th Percentile instead of Average (https://www.excelbanter.com/excel-discussion-misc-queries/111176-pivot-table-50th-percentile-instead-average.html)

J_Will

Pivot Table - 50th Percentile instead of Average

Can I calculate the median instead of the mean (average) in a pivot table?

All times are GMT +1. The time now is 06:27 PM.