Aggregate Formula - Median Values?
I have a simple table like this:
Item Value
===== ========
Apple 20
Apple 22
Apple 14
Apple 30
Orange 12
Orange 10
Orange 81
Orange 7
Orange 44
I need a way to get the median value for each 'Item' in the table. Using the Aggregate functionality with a pivot report seems like an ideal solution, however, 'Median' is not available as an aggregate function. If I were 'averaging' the numbers, this would work great, but it looks like I need to find another way to do this. Do I need to setup an SQL query? Hopefully, there's an easier way. Any help is appreciated.