Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Sum and transpose data

tiverson
8 - Asteroid

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
15 - Aurora

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