Aggregate measures at year level

[ewuchatka]

Hello

I'm an alteryx novice 🙂

I'd like to aggregate the below table so that it will have one line for a year for all the measures.

Please note it's a massive table with other dimensions (string) products, customers etc.  So for each customer and product the table has all the periods etc.

The required output will be ONLY aggregated for year, but the table will still be split by other all the fields like product, customer (and all the other hierarchies).

Please  note that I'd like to aggregate like that most (if not all!) measure i.e. units, volume, value etc.... so ideally it would be done in one go?

Before

Period	Year	Units
P1	2019	10
P2	2019	20
P3	2019	60

Required

Period	Year	Units
	2019	90

[RolandSchubert · Accepted solution]

Hi @ewuchatka ,

you can use the Summarize tool to aggregate the periods. In my understanding, source data has some dimensions (customer, product, year, period) and some measures (data fields like units, revenue). In the Summarize tool, all dimensions you want to keep (i.e. everything but "period") have to be selected as "Group by" field, all data fields can be added with Action "SUM", this will result in the year total by the respective combination of all dimensions. Hopew this is helpful.

Best,

Roland

[grossal · Accepted solution]

Hi @ewuchatka,

you can do this with the Summarize Tool.

I am not sure if I got it right, but it sounded like you want to keep the original columns, therefore I joined it back. If you don't need it, just remove the Join Tool.

Output 1:

Output 2:

I have attached the sample workflow. Let me know what you think.

Best

Alex

[ewuchatka]

thanks for a swift reply and help!