The average (aka mean) of a data set is misleading when there are one or more
unusually high or low values in that data set. Median is a much better
metric for central tendency in those cases, but it's not one of the Field
Properties options.

Pls add Median to the list of Field Options in pivot tables.

I am using Office Excel 2003 SP2

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions