How update the sum of a columns when filter is applied?

miccar

I have in the footer the sum of all data of a column, but when a filter is applied, only the data in the current page is summed, if i don't want to set paging:false, how can i manage the code of default DataTable example ?

kthorngren

I think you can try the selector-modifier as described in the columns().data() docs for this.

Kevin

miccar

From the example page, i replace page:'current' with filter:'applied' and all works fine

rimoi

thank you @miccar it helped me !

api.column(number_of_column , {filter:'applied'}).data()

salimkhan

I have use datatable, now i want to sum only the filtered price, how to do that plz
Thanks

colin

@salimkhan - I replied on your other thread - please only post once.

Colin