SUM/COUNT values for every year in a time span

[timol]

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!

[timol]

Thank you so much for your help

In the end I would like to do this for 3000 companies

So is there a way to do this automatically?

[afv2688]

Hello @timol ,

It could be automated if you have some kind of conditions that we can apply (or a table or place where we could get the data from)

Unless you have that you would need to do it manually

Regards

[timol]

Hello

the only Table I have available is the one below

But I think this covers all necessary information

Company	Founded	Certificates	Date
A	2015	1	12.01.2020
A	2015	2	12.01.2020
A	2015	23	12.01.2020
A	2015	21	12.01.2019
A	2015	21	12.01.2018
A	2015	21	12.01.2015
A	2015	21	12.01.2015
B	2019	23	12.01.2019
B	2019	42	12.01.2020
B	2019	23	12.01.2019
C	2016	1	12.01.2020
C	2016	2	12.01.2020
C	2016	23	12.01.2020
C	2016	21	12.01.2019
C	2016	21	12.01.2018
C	2016	21	13.01.2018
C	2016	21	14.01.2018

[afv2688 · Accepted solution]

Hello @timol ,

this should do it then

Regards