3 Replies Latest reply: Dec 21, 2017 4:18 AM by Marcus Sommer RSS

    2nd or 3rd highest value

    Josh Pinfold

      I have a list of categories each with an average score 'avg(EasyScore)'. I can use the first sorted value to generate the category with the highest average score but is there a way of getting the 2nd, 3rd or nth highest score. Maybe a combination of rank and agrr? The category field is 'SubSubCategory'.