Question: can pivot tables do median?
Answer: A frequent question that comes up when working with Excel PivotTables is how to calculate median using the table's filters and analysis. The short answer is “Excel doesn't do that”. Meaning, there isn't a simple way to change the Value Field Settings to calculate “Median”. The closest you can get is “Average”.