Hi All,

I've been struggling with this report that groups test scores. Users take a test and are allowed to take it multiple times. Currently I have it formatted as such:

Group # 1 (Score)
Group # 2 (User ID)
[User ID] [Name] [Score]

Group # 1 Specified Order:
0 - 25
26 - 50
51 - 75
76 - 100

I have attempted to use a formula to only use the maximum score value within Group # 2, however, Group # 1 sorts the scores first, so a person could have a score of 35 in one group and 55 in another. My goal is to somehow eliminate the 35 score.

I have also tried doing a top Nth based on the maximum score value under group # 2.

Thanks,

-D