SOLVED
Summarize rows in sequence groups
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Alchemist360
5 - Atom
‎05-30-2024
09:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 |
Solved! Go to Solution.
Labels:
- Labels:
- Transformation
4 REPLIES 4
Raj
16 - Nebula
‎05-30-2024
09:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Alchemist360
multi row formula will help to achieve this.
Raj
16 - Nebula
‎05-30-2024
09:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Alchemist360
please find the workflow attached
mark done if solved.
‎05-30-2024
09:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks much for the solution. I was thinking that the Row operation can go 1 row up or 1 row down. Thank you again!
Raj
16 - Nebula
‎05-30-2024
09:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Alchemist360
happy to help.