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,

      Eoghan