datatables summarise filtered data

Question

I'm using datatable jquery plugin in my site. All working well. However I'm trying to enhance the table by using the plugin script column filter and then I want to summarise the data in the footer. I can get the filter to work correctly. An example in datatables for summarising the data only works on either the page of data or the entire dataset. I found this thread: http://datatables.net/forums/discussion/2053/fnfootercallback-sum-column-after-filter/p1 looking for a similar solution. The author suggests the following function: ``` ._('td:nth-child(4)', {"filter": "applied"}) ``` This apparently returns an object of the filtered data. However once I have this I do not know where to start adding the data At the moment my datatable script (shortened for the sake of the post) looks like this: ``` table.dataTable({... "fnFooterCallback": function ( nRow, aaData, iStart, iEnd, aiDisplay ) { /* * Calculate the total sales for the table (ie inc. outside * the pagination) */ var iTotalSales…

Accepted Answer

When you run `._('td:nth-child(4)', {"filter": "applied"})` you get an array of that column's values returned to you. So if your table looks like this after being filtered:

```
col 1 | col 2 | col 3 | col 4
foo   | blah  |   $18 |   154
bar   | blech |    $2 |   109
```

...then the following command

```
var col4 = $('#mytable').dataTable()._('td:nth-child(4)', {"filter": "applied"})
```

...would give you `col4 = [154, 109]`. From there, you simply traverse col4 to sum its values, and manually insert the result into your footer row in the appropriate place.

datatables summarise filtered data

Solution

Problem