GROUPBY Function with Multiple Aggregations HSTACK and VSTACK in Excel 365
GROUPBY Function with Multiple Aggregations including HSTACK & VSTACK in #Excel 365
=VSTACK({"Category","Sales","",""},
GROUPBY(Data[Category],Data[Sales],
HSTACK(SUM,AVERAGE,PERCENTOF)))