Dear all,
I have the follwing type of data structure and would like to do a SUMIFS formula in Alteryx
| Company | Employees | Year | Founding |
| A | 3 | 2012 | 2013 |
| A | 4 | 2013 | 2013 |
| A | 5 | 2013 | 2013 |
| A | 23 | 2014 | 2013 |
| A | 535 | 2014 | 2013 |
| A | 2018 | 2019 | 2013 |
| A | 424 | 2020 | 2013 |
| A | 43 | 2020 | 2013 |
| A | 13 | 2017 | 2013 |
| A | 24 | 2018 | 2013 |
| A | 4 | 2014 | 2013 |
| A | 6 | 2014 | 2013 |
| A | 7 | 2019 | 2013 |
| A | 4 | 2020 | 2013 |
| A | 45 | 2020 | 2013 |
| A | 34 | 2017 | 2013 |
| A | 676 | 2018 | 2013 |
| B | 454 | 2019 | 2015 |
| B | 86 | 2018 | 2015 |
| B | 46 | 2017 | 2015 |
| B | 53 | 2017 | 2015 |
I want to SUMIF (accumulate) the number of employees for every year
I want to show the timespan from Founding year until 2018
so e.g. for 2017 I want to sum up all values <= 2017
the minimum Year should be the Founding year and the maximum year should be 2020.
Can anyone help me implementing this in Alteryx?
