Filter in Slice

[Billy]

I want to create a filter on the slice that shows me the amount of row I select in another view according to the value of the largest Collected. see the example

I want to type 5 and I just want it to show me the 5 machines with the largest 5 collected.

it's possible ? what's the best way to do it?

[Suvrutt_Gurjar · Accepted solution]

Your slice filter expression for top 5 machines can be something like

IN([Key Column] , TOP(ORDERBY(Table Name[Key Column], [Collected], TRUE),5))

IN() - AppSheet Help

TOP() - AppSheet Help

ORDERBY() - AppSheet Help

Please base your view on this slice.

[MultiTech]

You're creating what I call an 'enhanced dashboard'

• Here's a sample app if you're interested:
   - https://www.appsheet.com/templates/Manual-Version-of-Interactive-Dashboard?appGuidString=50341006-62...
• Build Video
   - https://youtu.be/HWhtlzxtPss