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
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