Hello,
I'm trying to make an aggregation based on elements contained on two rows. Here is an example of the input table:
| Org | DataElmt | Value |
| A | D1 | 1 |
| A | D1 | 2 |
| A | D2 | 3 |
| B | D1 | 4 |
| B | D1 | 5 |
| B | D2 | 6 |
| C | D1 | 7 |
| C | D1 | 8 |
| C | D2 | 9 |
And below the result I would like to have:
| Org | DataElmt | Value |
| A | D1 | 3 |
| A | D2 | 3 |
| B | D1 | 9 |
| B | D2 | 6 |
| C | D1 | 15 |
| C | D2 | 9 |
The "grouping" is made by "DataElmt" but for each "Org".
Can I have your help in doing it ?
Thanks in advance.
Best regards