Remove certain rows from sort

kralcen

Hi, i have been looking around the forums for posts on removing certain rows from the sorting of columns but the current posts have not really helped me too much. I have 2 rows at the bottom of a table that i want to always appear there no matter what, so if i sort a column it does not sort those 2 rows at the bottom. eg

Col1--Col2 Col3 Col4
row1-- 5 6 7
Total-- 1 4 3
Excess-2 5 9

So using the sort on one of the columns it would not include Total or Excess in its sort leaving those 2 rows there untouched. The values in the columns are all dynamic but the 2 rows with names Total and Excess with always have those names. So i am hoping to exclude based on the names.

I am hoping there is a way to do this with the custom sorting plugin.

I have been looking at this post here - http://datatables.net/forums/discussion/6089/disable-sorting-for-specific-rows./p1

Any help greatly appreciated

Cheers

kralcen

I have no discovered i also need to remove these from the filter as well