Question: can pivot table calculate median?
Answer: Unfortunately there's no built in way to calculate the median in a PivotTable. The approach is different depending on whether you're using a regular PivotTable or a Power Pivot PivotTable.