title: How to group multiple columns in jquery datatables
body: <p>How to collapse and expand the table based on multiple columns grouping.</p>
  
  <p>For example I have table like this</p>
  
  <pre><code>---------------------------------------------------------------
  location   |   size   | cont_no |   price  |  depot  |  cond  |
  ---------------------------------------------------------------
     USA     |    XX    |   123   |    230   |   SED   |    LK  |
     USA     |    YY    |   343   |    330   |   ASD   |    HK  |
     UAE     |    XX    |   233   |    230   |   SED   |    LK  |
     IND     |    ZZ    |   123   |    230   |   SAD   |    FK  |
     IND     |    XX    |   213   |    430   |   ASD   |    KK  |
     IND     |    YY    |   433   |    870   |   GFD   |    FK  |
     USA     |    YY    |   865   |    230   |   SED   |    LK  |
     UAE     |    XX    |   976   |    430   |   SED   |    HK  |
     USA     |    ZZ    |   342   |    230   |   CCD   |    HK  |
     UAE     |    XX    |   132   |    445   |   SED   |    KK  |
     UAE     |    ZZ    |   064   |    323   |   YYD   |    LK  |
     IND     |    YY    |   452   |    130   |   ITG   |    HK  |
  ---------------------------------------------------------------
  </code></pre>
  
  <p>This is how I need to group the above table</p>
  
  <pre><code>  -------------------------------
      location |  XX  |  YY  |  ZZ  |
      -------------------------------
         UAE   |   3  |   0  |   1  |
         USA   |   1  |   2  |   1  |
         IND   |   1  |   2  |   1  |
      -------------------------------
  </code></pre>
  
  <p>I want to group based on location and size column, Eg: USA has 3 XX and 0 YY and 1 ZZ,</p>
  
  <p>And then when i click the row i want to expand and show those 3 XX and 0 YY and 1 ZZ other four column  cont_no, price, depot, cond</p>
  
  <p>please someone help me or give me some suggestion or link for reference.</p>
  
  <p>Thank you</p>