Hey guys, I'm trying to figure out how to filter to just the median value plus five above and five below. For example - if the median value is 46, I want the filter to display 41-51. I found the filter option that lets you filter just the top n or bottom n, but I want the middle n, based on the most recent year. Does anyone know how to do this without writing SQL? I'm attaching my worksheet for reference, but I haven't attempted any calculations. Or rather, I haven't included any of my pitiful attempts at calculated fields.
Thanks!
Not exact, but kind of things?
[Reserch Rank latest Year]
{fixed[School]:sum({fixed [School],[Year Header]:min(if [Year Header]=2016 then [Research Rank] end)})}
[Count Scoool last year]
{fixed:count([Reserch Rank latest Year])}
[Filter Median]
[Reserch Rank latest Year]>=(([Count Scoool last year]/2-[Median X]))
and
[Reserch Rank latest Year]<=(([Count Scoool last year]/2+[Median X]))
Thanks,
Shin
