Select top/second/third record

I am having a problem with building a formula to help me select the top 3 performers based on their numerical achievements (sales). 

I've managed to select the top one using FIRST function and then the all three highest by using FIRST, 3 but I also would like to be able to select just the second highest record and the third highest record separately.  




1 comment

  • 0
    Meggan King

    Hi Ada

    Thanks for posting in the community! Do you want your values sorted as well as the top 3? First will just return the first 3 in your list, but you can use TOP filter to sort it and return the top 3. You can see more here: https://support.klipfolio.com/hc/en-us/articles/115004538487-How-do-I-filter-data-


    To do this through formulas, you can use SORT() to first sort your data, and then wrap it with a SLICE to select just 1, 2 or 3. 




    So there are a few ways you can solve this problem. Can you please give it a try and if you run into trouble, reach out to support@klipfolio.com?




Please sign in to leave a comment.