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,

#### 1 comment

• Meggan King

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