Top 10 most selling items

AppSheet AppSheet Q&A
1

Hello Dear Sir,

Let me ask a question.

How to create expression to get the top 10 most selling items?

In Google sheets I found the formula to get it.

That is sortn function.

Example

=Sortn(Range,10,0,2,0)

2 means selected range columns.

Let me know how to create expression in Appsheet?

Thanks Sir

2

Please use a combination of

TOP() and SORT() functions

or TOP() and ORDERBY() functions to get what you are looking at.

TOP() - AppSheet Help

SORT() - AppSheet Help

ORDERBY() - AppSheet Help

There ae many such questions in the past. please take a look at all those posts in the below link

Search - Google Cloud Community

3

Thanks for your help.

I am trying. But I didn’t get yet .

4

Hello,

try to carefully replace one by one this examples from this post with your needs.
remenber to check the keys from your table/source.

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Ranking-and-Top-10-chart/m-p/406121/highlight/true#M159468

5

Thanks I will follow.

6

If you could share the relevant tables/ columns structure with some sample or pseudo data and then describe what top 10 items you are looking for , the community can help better.