Dear Alteryx community,
I have the below requirement. Please let me know of a possible solution.
Input:
| Row No | Supplier | Month | Cost |
| 1 | A | 10/1/2024 | 100 |
| 2 | A | 11/1/2024 | 200 |
| 3 | A | 12/1/2024 | 300 |
| 4 | A | 1/1/2024 | 400 |
| 5 | A | 2/1/2024 | 500 |
| 6 | A | 3/1/2024 | 600 |
| 7 | A | 4/1/2024 | 700 |
| 8 | A | 5/1/2024 | 800 |
Required Output
| Sum of Rows | Supplier | Sum of Cost |
| 123 | A | 600 |
| 234 | A | 900 |
| 345 | A | 1200 |
| 456 | A | 1500 |
| 567 | A | 1800 |
| 678 | A | 2100 |
