Total by above line items

[kauser]

Hello, 

How can i get this following out put (Adding Total rows and % columns) from this input file 

Input Data 

Items	Currency	Amount
XY	EUR	345435
XY	USD	98787
AB	CAD	1232134
AB	USD	6746499
HG	EUR	-564848
HG	GBP	-253348

Expected Output Data 

Expected output
Items	Currency	Amount	Percentage
XY	EUR	345435	78%
XY	USD	98787	22%
XY TOTAL		444222
AB	CAD	1232134	15%
AB	USD	6746499	85%
AB TOTAL		7978633
HG	EUR	-564848	69%
HG	GBP	-253348	31%
HG TOTAL		-818196

[binuacs]

@kauser one way of doing this with batch macro

[Qiu]

@kauser 
I tried with a non-macro approach.

I go with the RecordID and sort the result with the RecordID afterwards.

[CoG · Accepted solution]

Another non-macro solution for the viewing pleasure of those who enjoy Tool Golf ;)

Hope this helps and Happy Solving!