Excel's GROUPBY function lets you group and aggregate data based on certain fields in your table of data ... (TabFood[Cuisine],TabFood[Sales],SUM) As well as using straightforward functions ...