Aggregation of attributes

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!

Aggregation of attributes.yxmd

Workflow

Datasets

Preparation

Database Connection

Accepted answers

vizAlter

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!

Aggregation of attributes.yxmd

All comments

vizAlter

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!

Aggregation of attributes.yxmd

Nadya

Thanks a lot!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703