Pivot Table: Need Medians instead of means

  • Thread starter Thread starter sigismundo
  • Start date Start date
S

sigismundo

I have a sheet (XL 2002 SP-2)with salary data for individuals by
department. I have used a pivot table to get summary statistics by
department (n, mean, max, min) but would like to get median salary by
department. Can this be done? I would appreciate any input.

chris
 
Hi
you can't use other functions in the pivot table. You may try to add a
helper column to your source data and use this helper column 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 Set Up 2
about pivot table 1
Pivot table calculated field 2
Median in pivot tables 5
Median in pivot table 1
Pivot Table Totals 1
Pivot Table exclude negative values from sum 2
Pivot: where does Excel store the data? 1

Back
Top