How can we help?

New post
0

Select top/second/third record

Avatar
Ada Zurawska
None
Follow

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.  

 

Thanks, 

Ada

Date Votes

1 comment

  • 0
    Avatar
    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. 

     

    SLICE(SORT(data),0,1)
    SLICE(SORT(data),1,2)
    SLICE(SORT(data),2,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?

     

    Thanks

    Meggan

Please sign in to leave a comment.