Only show the top 5 customers in my list

AppSheet AppSheet Q&A
1

How do I ONLY show the top 5 customers in my list?

Tiger1_0-1677013029040.png
Tiger1_0-1677013029040.png565×666 22.4 KB

2

https://help.appsheet.com/en/articles/895302-slices-the-essentials

https://help.appsheet.com/en/articles/2357282-top

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

1 Like
3

Thank you. I have tried using TOP and SORT but it doesn’t give me what I want.

My expression (As a virtual column):

Tiger1_0-1677086686515.png
Tiger1_0-1677086686515.png651×122 4.98 KB

Result:

Tiger1_1-1677086706116.png

I want the TOP 5 customer ]Customer Name] by [customer balance]. NO negatives!

4
  1. You need to build a Slice that only contains the top 5 records.
  2. The Slice expression should check each record’s key value against the list of key values that are the top 5.
  3. Get the list of top 5 key values with a TOP( ORDERBY( FILTER() ) ) expression.
1 Like
5

Thanks.

This is my slice but it isn’t working?

Tiger1_0-1677092880717.png
Tiger1_0-1677092880717.png946×700 37.9 KB

6

As the error says, that expression returns a List, you need it to return a yes/no value for each record in the table. You seemed to have missed my #2 item. Use IN()

1 Like