Median subtotals

stepone

Registered User.
Local time
Today, 01:57
Joined
Mar 2, 2004
Messages
97
Hi all,

I see several examples of Median functions on the forum - but they all calculate the median of an entire dataset. I'm looking for a version that would allow me to run a subtotal query with median values. To be specific, I've got a table with Job Title, Grade and salary. I want to group by Job Title and Grade, and display the median salary.

Does anyone have a version of a Median function which can do this ?

Thanks very much,
StepOne
 

Users who are viewing this thread

Back
Top Bottom