How to Group rows in a Pivot table like in Excel

Continuing with your food item example, add a column to your data table for the classification of vegetable or fruit. My table and pivot table below do not have any actual data, just the three "Rows" fields.

You can option-click on one of the triangles to collapse all of them in that column

It seems better to me to have the category in the data table vs being an ephemeral group in a pivot table. I notice in Excel that if I accidentally uncheck the field for the category (vegetable, fruit,..), all the groupings I made go away. Poof they are gone and they don't come back. If I do that in Numbers, I can simply click the field again and it all comes back (because it is all in the data table).