Adding total at the end

[kauser]

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

[flying008 · Accepted solution]

Hi, @kauser 

FYI.

Another way: