7 Replies Latest reply on Oct 6, 2016 6:38 AM by Shinichiro Murakami

    Filter the middle of the pack

    Sherrie Jennings

      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!