6 Replies Latest reply on Jan 18, 2018 2:53 AM by Eoghan Lyons

    Top N of a variable

    Eoghan Lyons

      Hi all,


      Is there a way to limit the Top N to a specific variable?


      I've setup a database with various events and for argument sake let's say participants.


      Is there a way where I can limit the scores to count to the Top 4, 5 scores that they record across however many events there are?


      E.g. John participates in 7 events, his scores are 1,2,3,4,5,6 and 7, is there a way where I could filter so that the records only show 4,5,6 and 7 for example?


      I attach a file with a rough outline of the sort of thing I'm looking at.


      Many thanks in advance,