Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default PLEASE add median in pivot tables PLEASE. PLEASE.

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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to create multiple Pivot tables at once havocdragon Excel Discussion (Misc queries) 3 July 27th 06 11:16 PM
Dynamically changing several pivot tables at once Jason Excel Discussion (Misc queries) 3 December 16th 05 03:50 PM
Median in pivot tables randdmiller Excel Discussion (Misc queries) 0 May 12th 05 04:08 PM
Macro for Pivot Tables Thomas Excel Discussion (Misc queries) 1 March 15th 05 01:03 AM
Can I use median function in Pivot Tables? larrymorris4 Excel Worksheet Functions 2 December 30th 04 06:49 PM


All times are GMT +1. The time now is 06:25 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"