Show columns in a summmarized table

I have a query which joins Products and Sales then summarizes by Sum of Sales by Product Title, to show sales by Product in a table.

In the table view it only shows the Title and Sum columns, how can I show other columns from the Products table in the same view?

add the columns in the group by

1 Like

Ah thanks! I just had to turn off "Pivot Table" in the table settings after I added the second group