Excel's Pivot Table & Subtotal function should have a median fie.

G

Guest

Excel Pivot Table fields have a range of functions to choose from (i.e.
average, counta...) I like to see the median function added to that list
since averages may be skewed by outliers and median will allievate that
problem a bit. Also if median could be included as one of the options for
the subtotal function
 
F

Frank Kabel

Hi
as this is a peer-to-peer NG you may send this to
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtotal the median 1
Subtotal based on a range of data in Pivot Table 5
Formulas available in pivot table and grouping drop-down menus 1
Median Value in Pivot Table 2
Subtotal percents in pivot table 1
How to create a VBA function which can be used within a query 11
median of combinations from values in a column 6
Pivot Table - Weight Average 2

Top