Excel Pivot Table Value Field Settings for Median

Topic

New Reply

I am hoping someone can help me out by devising a method for adding “Median” as a choice in the the Value Field Settings of a pivot table. I am fairly new to pivot tables so there may already be an option for this that I do not know about. Please help by providing any advice you may have if there is a way I am overlooking.

Thank you

Reply | Quote

Replies

In the PivotTable Field List, click on the field in the Values area > Value Field settings…. > Summarize Values by tab > Average.

HTH,
Maud

Reply | Quote

Thank you for responding Maudibe

Reply | Quote

That is a known shortcoming of pivot tables. There is no option for and any workaround to get median. Average is mean not median.

Reply | Quote

Thank you for responding Zeno. Thank you also for the information. I must say though, from a determined standpoint, I am kind of hoping you are wrong about the no work around part if you know what I mean.:)

Reply | Quote

There is no workaround – you can’t add functions to that dropdown, and there is no way to calculate what you need with a calculated field either. If you have Power Pivot it might be possible. Failing that, you’d have to use formulas outside (or instead of) your pivot table.

Reply | Quote

Thank you for your response rory

Reply | Quote