I got a datatable fill with either 1 or blank. The IQueryable object was originally Y or N. Just before I bind the data to the datatable, I changed it to 1 or blank with <%# Item.DataField == "Y" ? "1" : "" %>At the bottom of the datatable, I need to add a footer row Total: 23 24 23, which the number is the sum of each columns ie adding all the 1's.I look at the following example with fnDrawCallBack. In the sum+= line, I am not sure about the ._aData.{your item}. What is "your item"?Any help is greatly appreciated.\[code\]$(document).ready(function () {var oResultGrid = $("[id$='gvReportData']");if (fixEmptyDataRow(oResultGrid)) {var oTable = oResultGrid.dataTable({"bPaginate": false,"bFilter": false,"bInfo": false,"fnDrawCallback": function (oSettings) {// Get all rows of your tablevar nTrs = $tableElement.find('tbody tr');// Enumerate all rowsvar sum = 0;for (var i = 0; i < nTrs.length; i++) {var iDisplayIndex = oSettings._iDisplayStart + i;var dataIndex = oSettings.aiDisplay[iDisplayIndex];sum += oSettings.aoData[dataIndex]._aData.{your item};}// Insert sum at the end$tableElement.find(' tbody tr:last').after('<p>'+sum+'</p>');});}else {oResultGrid.dataTable({"sPaginationType": "full_numbers","aaSorting": [[1, 'asc']],"fnDrawCallback": function (oSettings) {// Get all rows of your tablevar nTrs = $tableElement.find('tbody tr');// Enumerate all rowsvar sum = 0;for (var i = 0; i < nTrs.length; i++) {var iDisplayIndex = oSettings._iDisplayStart + i;var dataIndex = oSettings.aiDisplay[iDisplayIndex];sum += oSettings.aoData[dataIndex]._aData.{your item};}// Insert sum at the end$tableElement.find(' tbody tr:last').after('<p>'+sum+'</p>');});}});function fixEmptyDataRow(table) {// Check Contents of 1st TD tag in table. If it contains the EmptyDataRows text, then this is an Empty Data Rowvar value = http://stackoverflow.com/questions/15569549/$(table).children('tbody').children('tr').children('td:first').text().trim();// Prepend THEAD required by JQuery DataTables for the EmptyDataRow Tableif (value =http://stackoverflow.com/questions/15569549/="No results match your query") {// EmptyDataItems templatetable.prepend("<THEAD><TH></TH></THEAD>");return true;}elsereturn false;} \[/code\]