HI Team,
I have the below requirement.
Input:
| row no. | EMP ID | Code | A | B |
| 1 | 123 | L | 19 | |
| 2 | 123 | L | 30 | |
| 3 | 123 | L | 32 | |
| 4 | 123 | L | 37 | |
| 5 | 123 | D | 14 | |
| 6 | 123 | D | 24 | |
| 7 | 123 | D | 37 | |
The Column B calculation should be done grouped by EMP ID & Code. Wondering if this can be achieved through multirow tool. Appreciate any help around this.
Required Output:
| row no. | EMP ID | Code | A | B | | |
| 1 | 123 | L | 19 | 19 | | B1=A1 |
| 2 | 123 | L | 30 | 11 | | B2=A2-A1 |
| 3 | 123 | L | 32 | 2 | | B3=A3-(A2+A1) |
| 4 | 123 | L | 37 | 5 | | B4=A4-(A3+A2+A1) |
| 5 | 123 | D | 14 | 14 | | B6=A6 |
| 6 | 123 | D | 24 | 10 | | B7=A7-A6 |
| 7 | 123 | D | 37 | 13 | | B8=A8-(A7+A6) |
