SOLVED
Group by row value and sum of the column values
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
vinothdeva
7 - Meteor
‎04-23-2018
09:42 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
How do i group by a row value and find the corresponding sum in column values.
Input:
A | 1 | 2 |
A | 10 | 4 |
B | 2 | 5 |
B | 4 | 7 |
output
A | 11 | 6 |
B | 6 | 12 |
Solved! Go to Solution.
Labels:
- Labels:
- Transformation
2 REPLIES 2
haroon_sa
10 - Fireball
‎04-23-2018
09:53 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
jmarsch
5 - Atom
‎06-02-2020
06:59 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am trying to do something very similar to this. However, it does not sum all the rows in the fields I am grouping by so the sum is less than it should be. Any ideas on what is wrong?
