SUM/COUNT values for every year in a time span

Dear all,

I have the following data structure

A	1	12.01.2020
A	2	12.01.2020
A	23	12.01.2020
A	21	12.01.2019
A	21	12.01.2018
A	21	12.01.2015
A	21	12.01.2015
B	23	12.01.2019
B	42	12.01.2020
B	23	12.01.2019
C	1	12.01.2019

Now I would like to just sum the values in the second column for every year 2015-2020 to get this output

I would like to accumulate values in every year.

But (for whatever reason) one company has only values for 2015, 2018, 2019 and 2020.

I still want to have values for 2017-2019.

A	2015	42
A	2016	42
A	2017	42
A	2018	63
A	2019	84
A	2020	110

Does anyone have an idea how to do that in Alteryx?

Thank you so much!

Workflow

Accepted answers

afv2688

Hello @timol ,

Could you please explain what is wrong with this solution?

As far as I can see the acumulated results are there.

Regards

grop by.yxmd

afv2688

Hello @timol ,

this should do it then

Regards

grop by.yxmd

All comments

afv2688

Hello @timol ,

does this work for you?

Regards

grop by.yxmd

timol

Thank you!!

But what I would like to do is list a value for every year in a timespan (so also 2016 and 2017, see the table below)

A	2015	42
A	2016	42
A	2017	42
A	2018	63
A	2019	84
A	2020	110

afv2688

Hello @timol ,

sorry for that, interpreted what I wanted not what was written 😥

Regards

grop by.yxmd

timol

Thanks again for the super fast response

But what I would like to do is place the accumulated value of all previous years in the fied

currently is says for the years that are not explicitly mentioned "Null"

afv2688

Hello @timol ,

Could you please explain what is wrong with this solution?

As far as I can see the acumulated results are there.

Regards

grop by.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703