0
2K
ViewsJquery DataTable: Sum table rows and columns
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
·
Juan Pablo Isaza
1 answers
Answer question0
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 thetheadThen add new column in
columnswhile 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); } }
·
Juan Pablo Isaza
Report
Answer question