Hello,
can you please let me know how to add total at the end of each section -
Input Data
| Item1 | DR |
| A | 10 |
| A | 20 |
| A | 25 |
| A | 60 |
| B | 546 |
| B | 2343 |
| B | 678 |
| B | 34324 |
| C | 689 |
| C | 1232 |
| C | 67867 |
| C | 56 |
| D | 4567 |
| D | 123 |
| D | 456 |
| D | 678 |
Output Data-
| Item1 | DR | CR |
| A | 10 | |
| A | 20 | |
| A | 25 | |
| A | 60 | |
| | | 115 |
| B | 546 | |
| B | 2343 | |
| B | 678 | |
| B | 34324 | |
| | | 37891 |
| C | 689 | |
| C | 1232 | |
| C | 67867 | |
| C | 56 | |
| | | 69844 |
| D | 4567 | |
| D | 123 | |
| D | 456 | |
| D | 678 | |
| | | 5824 |
