How to create a top sales ranking

AppSheet AppSheet Q&A
,
1

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
2

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.

Suvrutt_Gurjar_0-1649823730174.png
Suvrutt_Gurjar_0-1649823730174.png1022×633 47.5 KB

OR else

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

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

  1. 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

2 Likes