title: Group by ID and Sum Amount in XSLT
body: <p>I'm fairly new to XSLT and stuck on a current problem. I've done some searches throughout Stackflow (seems like Muenchian method is the common group method) but I can't seem to mimic some of the posted ideas as of yet. </p>
  
  <p>So I'm using a line item read system of which I'm trying to write code in XSLT to read every line to check if the supplier ID is the same, if true, it will aggregate this into one line, then sum the amounts. If not true, it should start a new line with the ID and sum the amount and so forth. I am using xml version='1.0'</p>
  
  <p><strong>Below is my current data file in XML:</strong></p>
  
  <pre><code>&lt;data&gt;
  &lt;row&gt;
      &lt;column1&gt;06-11111&lt;/column1&gt;
      &lt;column2&gt;CP&lt;/column2&gt;
      &lt;column3&gt;744.04&lt;/column3&gt;
      &lt;column4&gt;CAD&lt;/column4&gt;
  &lt;/row&gt;
  &lt;row&gt;
      &lt;column1&gt;06-11111&lt;/column1&gt;
      &lt;column2&gt;CP&lt;/column2&gt;
      &lt;column3&gt;105.09&lt;/column3&gt;
      &lt;column4&gt;CAD&lt;/column4&gt;
  &lt;/row&gt;
  &lt;row&gt;
      &lt;column1&gt;06-11111&lt;/column1&gt;
      &lt;column2&gt;CP&lt;/column2&gt;
      &lt;column3&gt;1366.24&lt;/column3&gt;
      &lt;column4&gt;CAD&lt;/column4&gt;
  &lt;/row&gt;
  &lt;row&gt;
      &lt;column1&gt;06-11111&lt;/column1&gt;
      &lt;column2&gt;CP&lt;/column2&gt;
      &lt;column3&gt;485.71&lt;/column3&gt;
      &lt;column4&gt;CAD&lt;/column4&gt;
  &lt;/row&gt;
  &lt;row&gt;
      &lt;column1&gt;06-11112&lt;/column1&gt;
      &lt;column2&gt;Ever&lt;/column2&gt;
      &lt;column3&gt;459.60&lt;/column3&gt;
      &lt;column4&gt;CAD&lt;/column4&gt;
  &lt;/row&gt;
  &lt;row&gt;
      &lt;column1&gt;06-11112&lt;/column1&gt;
      &lt;column2&gt;Ever&lt;/column2&gt;
      &lt;column3&gt;409.14&lt;/column3&gt;
      &lt;column4&gt;CAD&lt;/column4&gt;
  &lt;/row&gt;
  &lt;row&gt;
      &lt;column1&gt;06-11112&lt;/column1&gt;
      &lt;column2&gt;Ever&lt;/column2&gt;
      &lt;column3&gt;397.12&lt;/column3&gt;
      &lt;column4&gt;CAD&lt;/column4&gt;
  &lt;/row&gt;
  &lt;row&gt;
      &lt;column1&gt;06-11113&lt;/column1&gt;
      &lt;column2&gt;GE&lt;/column2&gt;
      &lt;column3&gt;1425&lt;/column3&gt;
      &lt;column4&gt;CAD&lt;/column4&gt;
  &lt;/row&gt;
  &lt;row&gt;
      &lt;column1&gt;06-11114&lt;/column1&gt;
      &lt;column2&gt;Husky&lt;/column2&gt;
      &lt;column3&gt;-215.14&lt;/column3&gt;
      &lt;column4&gt;USD&lt;/column4&gt;
  &lt;/row&gt;
  &lt;row&gt;
      &lt;column1&gt;06-11114&lt;/column1&gt;
      &lt;column2&gt;Husky&lt;/column2&gt;
      &lt;column3&gt;2015&lt;/column3&gt;
      &lt;column4&gt;USD&lt;/column4&gt;
  &lt;/row&gt;
  &lt;row&gt;
      &lt;column1&gt;06-11114&lt;/column1&gt;
      &lt;column2&gt;Husky&lt;/column2&gt;
      &lt;column3&gt;11195.34&lt;/column3&gt;
      &lt;column4&gt;USD&lt;/column4&gt;
  &lt;/row&gt;
  &lt;/data&gt;
  </code></pre>
  
  <p><strong>The output I would like to achieve after running the XSLT is</strong></p>
  
  <p>06-11111 |     CP          |2701.08</p>
  
  <p>06-11112 |     Ever        |1265.86</p>
  
  <p>06-11113 |     GE          |1425</p>
  
  <p>06-11114 |     Husky       |12995.20</p>
  
  <p>Any help to get me started would be fantastic!</p>