Filter a View to show only Top 5

I have a View to display Grouped and Summarized data from another table.

It's possible to filter the View to display only the Top-5 records (based on the Summary field)?

Screen Shot 2019-04-20 at 20.59.15

- Sean
- 5 yrs ago
- Reported - view
Nick, I think you will need to do something similar to this thread...

https://ninoxdb.de/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/can-you-do-secondary-sorts-within-a-view-5bf45478d91e505c0994c84e

Create a formula field with code similar to this...

let t := this;
let myGroup := (select Table1 where Group = t.Group).Number;
sum(myGroup)

Filter on the formula field. It looks like the filtering options are limited so you would have to pick the 6th largest number manually and use > than that number in the filter of the formula field. I'm imagine there are other ways, but that's my contribution. :)
- Nick
- 5 yrs ago
- Reported - view
Thanks Sean, I think we'll find a workaround in the end...

Content aside