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!
Solved! Go to Solution.
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?
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
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 |