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