In this case if you just care about the max TotalScore, you can just reverse-sort your data by TotalScore and use head to grab to first (aka the max) one: | makeresults format=csv data="Class,Nam...
See more...
In this case if you just care about the max TotalScore, you can just reverse-sort your data by TotalScore and use head to grab to first (aka the max) one: | makeresults format=csv data="Class,Name,Subject,TotalScore,Score1,Score2,Score3
ClassA,Name1, Math, 170, 60 ,40 ,70
ClassA,Name1, English ,195, 85, 60, 50
ClassA,Name2, Math, 175, 50, 60, 65
ClassA,Name2, English ,240, 80, 90, 70
ClassA,Name3, Math, 170, 40, 60 ,70
ClassA,Name3, English ,230, 55, 95, 80"
| sort -TotalScore
| head 1
| table Class Name, Subject, TotalScore, Score1, Score2, Score3 Here's a screenshot: