Using median formula on Pivot table

SydneyGeek

MrExcel MVP

Joined

Aug 5, 2003

Messages

12,251

• Aug 17, 2003

• #2

You can't pick Median from the list like Average, Max, Min and the others, but you can insert a calculated field and use Excel's built-in MEDIAN function.

Right-click on the pivot table, select Insert | Calculated Field, and follow the prompts.

Hope that helps.

 

Upvote 0

U

u_niv

New Member

Joined

Aug 17, 2003

Messages

25

• Aug 17, 2003

• #3

Thanks for your help SG.

I tried your suggestion but the results was similar to that of a sum() function.

Did I miss anything ? is there another way ?

10x,
Y.

 

Upvote 0

M

Mark W.

MrExcel MVP

Joined

Feb 10, 2002

Messages

11,654

• Aug 18, 2003

• #4

MEDIAN is not supported by PivotTables. A list of supported summary functions can be found in the Excel Help topic for "Summary functions for data analysis".

A calculated field cannot be used for this purpose. The median of a single, summed value is that value.

 

Upvote 0

J

Joe C

Well-known Member

Joined

Oct 17, 2002

Messages

841

• Jan 22, 2004

• #5

I am trying to find list of acceptable functions mentioned, but cannot seem to follow help their. Can someone tell me how to get to it in help index?

 

Upvote 0

J

Joe C

Well-known Member

Joined

Oct 17, 2002

Messages

841

• Jan 22, 2004

• #6

I found a way around what I need using a formula from Juan P.
But why in the world would the genuises at Microsoft leave out the median of all things.

 

Upvote 0

P

PaddyD

MrExcel MVP

Joined

May 1, 2002

Messages

14,234

• Jan 22, 2004

• #7

"I am trying to find list of acceptable functions mentioned, but cannot seem to follow help "

review the help topic "Summary functions for data analysis"

 

Upvote 0

J

Joe C

Well-known Member

Joined

Oct 17, 2002

Messages

841

• Jan 22, 2004

• #8

Found it, thank. I still cant believe they left out the Median, but I guess it is in the way it is stored.

 

Upvote 0

M

Mudasir.Khan

New Member

Joined

Jun 2, 2009

Messages

3

• Nov 1, 2010

• #9

Dear All,


C:\Documents and Settings\Mudasir\Desktop\PT_Median.xlsm


Thanks and kind regards,

Mudasir Khan

 

Last edited: Nov 1, 2010

Upvote 0

M

Mudasir.Khan

New Member

Joined

Jun 2, 2009

Messages

3

• Nov 1, 2010

• #10

Hi All,

The solution to the subject is here: -

Please visit following link to download the solution file.

http://www.4shared.com/file/8Lxkbfvk/PT_Median.html


Thanks and kind regards,

Muhammad Muddassir Khan

 

Upvote 0