Only show the top 5 customers in my list

[Tiger1]

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

[Marc_Dillon]

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

[Tiger1]

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

My expression (As a virtual column):

Result:

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

[Marc_Dillon]

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.

[Tiger1]

Thanks.

This is my slice but it isn't working?

[Marc_Dillon]

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()