I want to create a table where ROW AND COLUMN sums both are displayed
Footer Callback covers showing running column sums https://datatables.net/examples/advanced_init/footer_callback.html
But I would like to have like below Picture a footer row summing the columns and the last column showing row sums and it should work together with row and column filtering
Could someone please tell me how to do it with JQuery DataTables
To show the sum of row, you'll need to add a new column 'Total' just like in your image. You can show the sum of particular columns in this.
First add new <th>Total</th> in the thead
Then add new column in columns while initializing dataTable
{
"targets": 0,
"data": null,
"render": function ( data, type, row, meta ) {
return parseInt(row.column1,10) + parseInt(row.column2,10) + parseInt(row.column3,10);
}
}