sum filter columns

Massimo74

http://live.datatables.net/wudevazo/1/edit

I calculate the total of column 3 (age), and so far everything is ok, but now I would like the total to refer to all the people in column 2 = London

kthorngren

Instead of using Javascripts reduce() method you would need to iterate over the rows. You could use rows().every() then inside the loop if the Position column contains London increment your counter by the value in the age column. Soemthing like this:

http://live.datatables.net/hoxinawa/1/edit

Kevin