Pivot Tables & Median

  • Thread starter Thread starter steve
  • Start date Start date
S

steve

How do you make a pivot table calculate median through the
calculated feild option or is there another simple elegant
way?
 
Hi Steve
you can't add the median to a pivot table. You may use a helper column
in your source table and use this helper column as new data item in
your pivot table
 
You must log in or register to reply here.

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

Pivot Table 1
Calculating using the Median function?? 3
a query for pivot table 1
Median in Excel 2007 pivot-tables 1
Median Function 2
median standard deviation 7
Median 3
Formulas available in pivot table and grouping drop-down menus 1

Back
Top