Pivot Table: Need Medians instead of means
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 -- Regards Frank Kabel Frankfurt, Germany "sigismundo" schrieb im Newsbeitrag om... 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 |
All times are GMT +1. The time now is 04:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com