Here below is a data table:

We want to group by Class, and calculate the average score of each subject of each class:

=spl("=E(?1).groups(Class;avg(Maths):Maths,avg(English):English,avg(PE):PE)",A1:E12)

esProc Desktop and Excel Processing
10.14 Rank in group
11.2 Group by combination of multiple columns