Aggregation of attributes

[Nadya]

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

Required View

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!

[vizAlter · Accepted solution]

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:

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

[Nadya]

Thanks a lot! 

[vizAlter]

@Nadya — Thank you!