How to create a top sales ranking

[EduardoCardoso]

I have this table and I want to create a view that only shows me the 2 names that sold the most. How can I do it ?

ID	Name	sold	date
fdsfsd	Eduardo	10	02/20/2022
fdsf23	Jack	200	02/20/2022
fdsf54	Sam	600	02/20/2022
fdsf76	Bill	200	02/20/2022
fdsf43	Eduardo	200	02/20/2022
fdsf76	Bill	100	02/20/2022
fdsf65	John	20	02/20/2022
fdsf23	Sam	30	02/20/2022

[Suvrutt_Gurjar]

Please evaluate below options.

1. You could simply sort on the [Sold] column in your table view  by tapping on the [Sold] column heading if you are allowing summary views sorting by the user.

OR else

2. You could use sort by [Sold} column in the table view.

https://help.appsheet.com/en/articles/961513-controlling-row-sort-order

3. Or else if you are only needing the top 2 sellers in the view,

Please create a slice with an expression

IN([ID], TOP(ORDERBY(Table Name[ID], [Sold], TRUE),2))

Please base your view on that slice.

https://help.appsheet.com/en/articles/2357312-orderby