How to use sum of and group by in etext template

Hi Experts,

I Have the attached xml file where i want sum up run amount based on balance type name.

for example

Payroll Check Date	Element / Balance Name	Amount
Taxable Benefits	Grp Term Life	.28
Standard Earnings	Holiday Pay	60
Supplemental Earnings	Leasing Comm	50
Standard Earnings	Holiday Pay	20
Supplemental Earnings	Leasing Comm	10

I need data as below

Payroll Check Date	Element / Balance Name	Amount
Taxable Benefits	Grp Term Life	.28
Standard Earnings	Holiday Pay	80
Supplemental Earnings	Leasing Comm	60

Could you please help me how to acheive that logic