How do I summarize totals based on matching data in multiple columns?

[atarahoward]

I am trying to consolidate/combine data where certain column data is the same but the sales and costs are on different lines. How can I consolidate this list and summarize the sales and costs into one line?

[reedy212]

Should be able to use a standard summarize tool

[acarter881]

Hello, @atarahoward.

Please see the attached workflow for the subtotals and totals. The sorting happens to work favorably in this scenario. It can be more complex, but the idea is similar.