11.2 Group by combination of multiple columns

 

Here below is a data table:

imagepng

We want to group by Year and Quarter, and count the total sales of each quarter:

=spl("=E(?1).groups(Year,Quarter;sum(Sales):Sales)",A1:D25)


imagepng


esProc Desktop and Excel Processing
11.1 Simple grouping
11.3 Group by expression