max
1 Topic
Only return top N rank by group
Hi, I would like some guidance to return the top ranked record per group. For instance, from the following dataset: Division Team Total Player Score Premier Spurs 26 Kane 9 Premier Spurs 26 Son 11 Premier Spurs 26 Lucas 6 Premier Liverpool 19 Mane 11 Premier Liverpool 19 Salah 8 Premier Southampton 7 Ings 7 Premier City 28 Sterling 7 Premier City 28 DeBruyne 9 Premier City 28 Aguero 12 The correct output would be: Division Team Total Player Score Premier Spurs 26 Son 11 Premier Liverpool 19 Mane 11 Premier Southampton 7 Ings 7 Premier City 28 Aguero 12 Note that Total is the sum of Score by Team. Ideally, I would like to retain the Total summary if possible, but only display one record by Team with Max Score value. Is this possible?Solved1.5KViews0likes5Comments