title: Struggling to position a total row at the bottom of a DataTables table
body: <p>I've tried to post on their forum for the past two weeks but my posts or topics never show.</p>
  
  <p>I create the table as HTML from the server side before converting it into a DataTable. The total is processed server side (as it's not as simple as just adding them all up, there's averages and all sorts). <a href="http://live.datatables.net/ofexun/edit#javascript,html" rel="nofollow">Here's the original table.</a> As you can see, the Total row is ordered within the table like any other row.</p>
  
  <p>I've tried putting the total row in the footer, but this causes the horizontal scroll bar to be in between the data and total row. <a href="http://live.datatables.net/eduqep/edit#javascript,html" rel="nofollow">See this example</a>. This is because the horizontal scroll bar is applied to the tbody table. The footer is part of its own table due to how FixedColumns works... I tried to manually recreate the effect by disabling the horizontal scroll bar in the DataTables constructor and wrapping it in a fixed width div... It worked but FixedColumns didn't as it requires that a scroll width be set...</p>
  
  <p>I've tried to restructure the table with jQuery during the draw callback of the DataTable, but FixedColumns makes such a mess of the HTML that I couldn't do it (there's about 4 tables, all in containing divs, all with hidden/stripped headers/bodys/footers just for the one table). I won't post the code as it wasn't functional, but it involved tagging the row with a class, finding said row, cloning it, remove the original, then append the cloned row to the bottom of the tbody. Even if this works it'll break the formatting too as odd/even rows were shifted to be next to each other =/ </p>
  
  <p>I tried to write my own sort function to always put the Total at the bottom but it only worked when sorting by the name (as that was the only time I had access to the words 'total' as it only has the data for that column).</p>
  
  <p>I feel like I'm going about this totally wrong as surely someone's needed a server side total row before... All the examples I can find, are not using a FixedColumn.</p>