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

  • Thread starter Thread starter Guest
  • Start date Start date
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
 

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

Lack of 'median' as a function option in pivot tables 0
Average of Subtotals in Pivot Table 0
Subtotal the median 1
Summarize by "Median" in the Pivot Table Field for Excel 2
Can I use median function in Pivot Tables? 2
creating new function in Excel for Medians 3
Conditional Median calculation from a database 6
Create Detail Sheets from Pivot Table 1

Back
Top