Using the Median Function within a Pivot Table
Posted by Wendy Hubbard on February 14, 2002 2:08 PM
I have approximately 27,000 records which I'm trying to find the median value. The records contain the following fields: Hour, Category & Wait Time. I need to group the records by Hour (00:00 to 24:00) then by Category (1,2,3,4 or 5) and find the median value of the Wait Time (stored in minutes).
I've used a pivot table to look at frequency by the hour which works fine and also Averge Wait Time by Hour/by Category. I just need to find a way to work out Median.