使DataTables合计行不受排序/筛选的影响

$('#example').DataTable({
  //其他配置项
  "footerCallback": function (row, data, start, end, display) {
    var api = this.api();

    //计算合计值
    var sum = api.column(4, { page: 'current' }).data().sum();

    //更新合计行的数值
    $(api.column(4).footer()).html(sum);
  }
});

$('#example').DataTable({
  //其他配置项
  "columnDefs": [
    {
      "targets": 4,
      "render": function (data, type, row, meta) {
        if (type === 'display') {
          //计算合计值
          var api = this.api();
          var sum = api.column(4, { page: 'current' }).data().sum();

          //显示合计值
          return sum;
        }
        return data;
      }
    }
  ]
});