Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Sum and transpose data

tiverson
7 - Meteor

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

 

Original Data:

tiverson_0-1635276828194.png

 

Desired Outcome:

tiverson_1-1635276852655.png

 

2 REPLIES 2
drew9
9 - Comet

Hi @tiverson ,

 

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

 

Hope this helps!

ChrisTX
13 - Pulsar

Use Transpose and Summarize

 

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

 

ChrisTX_0-1635277438074.png

 

 

Chris

Labels