Is there a way to report only the bottom 10 and top 10 in the same view?
Please do let me know if there is.
here's one way to do it. You need to use a parameter and a mix of INDEX() to get the ranking, and WINDOW_MAX to find the "bottom" n.
Retrieving data ...