Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Aggregation of attributes

Nadya
5 - Atom

Hi, 

 

I am trying to create an aggregation of a few attributes and then summing their values so I have 2 rows instead of 4 in the case below. 

 

Initial View

Nadya_0-1600875040318.png

 

Required View

Nadya_1-1600875061555.png

 

I am sure there is a simple way to do it but it is taking me a lot of time to figure it out!

 

Thanks a lot in advance!

 

3 REPLIES 3
vizAlter
12 - Quasar

Hi @Nadya — Welcome to the Alteryx Community!
You need to use the "Summarize" tool which is available in "Transform" ribbon tab, then sort your data using "Sort" tool:

 

vizAlter_0-1600875764562.png

 

If this solves your issue please mark the answer as "Solved" with a Like, if not let me know!

Nadya
5 - Atom

Thanks a lot! 

vizAlter
12 - Quasar

@Nadya — Thank you!

Labels
Top Solution Authors