Sum and transpose data

[tiverson]

I am trying to Summarize data by type with summarized cost categories:

Original Data:

Desired Outcome:

[drew9 · Accepted solution]

Hi @tiverson ,

Attached is the solution. Update the input to be pointed to your local machine for the desired results.

Hope this helps!

[ChrisTX · Accepted solution]

Use Transpose and Summarize

You'll need to add in a few tools to get your custom sort order

Chris