查找含有相同元素的节点问题

大虾请看看:

我的xml代码如下:

<data>
  <Record>
  <Row>
  <MemberName type="String">MR XX</MemberName>
  <Reference type="String">111111</Reference>
  <Book type="String">RRR</Book>  
  <Price type="Currency">1.35</Price>
  </Row>
  <Row>
  <MemberName type="String">MR YY</MemberName>
  <Reference type="String">222222</Reference>
  <Book type="String">MMM</Book>  
  <Price type="Currency">2.78</Price>
  </Row>
  <Row>
  <MemberName type="String">MR ZZ</MemberName>
  <Reference type="String">333333</Reference>
  <Book type="String">RRR</Book>  
  <Price type="Currency">1.35</Price>
  </Row>
  <Row>
  <MemberName type="String">MR ZZ</MemberName>
  <Reference type="String">333333</Reference>
  <Book type="String">MMM</Book>  
  <Price type="Currency">2.78</Price>
  </Row>
  <Row>
  <MemberName type="String">MR SS</MemberName>
  <Reference type="String">555555</Reference>
  <Book type="String">YYYY</Book>  
  <Price type="Currency">3.68</Price>
  </Row>
  <Row>
  <MemberName type="String">MR SS</MemberName>
  <Reference type="String">555555</Reference>
  <Book type="String">MMM</Book>  
  <Price type="Currency">2.78</Price>
  </Row>
  </Record>
</data>

需要查找reference相同的节点. 我要输出的结果是:

MemberName Reference Book Price
MR XX 111111 RRR 1.35
  Totals:1.35

MR YY 222222 MMM 2.78
  Totals:2.78

MR ZZ 333333 RRR 1.35
  MMM 2.78
  Totals:4.13

MR SS 555555 YYYY 3.68
  MMM 2.78
  Totals:6.46

   
 

C# code

MemberName Reference Book Price Total
MR XX       111111   RRR   1.35 1.35

MR YY       222222   MMM   2.78 2.78

MR ZZ       333333   RRR   1.35 4.13
MR ZZ       333333   MMM   2.78 4.13

MR SS       555555   YYYY  3.68 6.46
MR SS       555555   MMM   2.78 6.46

可否以这样的格式输出？