Convert xml to dict and group data and sum totals

[kashcode]

Hello,

I have xml file with data.
What I need to do. Group data by siteid and merchantname and sum totals from clicks, downloads, newdepositingacc, netrevenue, revsharecommission.
The result I would like to achieve could be something like this:

[{
  'name': 'http://gamblerguy.com (LeoMonaco)',
  'clicks': 'sum clicks totals',
  'downloads': 'sum clicks downloads',
  'newdepositingacc': 'sum newdepositingacctotals',
  'netrevenue': 'sum netrevenue totals',
  'revsharecommission': 'sum revsharecommission totals' 
},
{
  'name': 'casinochimp.com (LeoMonaco)',
  'clicks': 'sum clicks totals',
  'downloads': 'sum clicks downloads',
  'newdepositingacc': 'sum newdepositingacctotals',
  'netrevenue': 'sum netrevenue totals',
  'revsharecommission': 'sum revsharecommission totals'
}]