Hi All,
Anyone know if the tableFilter plugin (
http://ideamill.synaptrixgroup.com/jquery/tablefilter/tabletest.htm )
can do sums? There are two things that I need for an app:
1. summing (specific) cols in the last row or footer of the table:
Category | Number
------------------------
Food | 3
Food | 4
------------------------
Sum | 7
2. subtotalling cols by "grouping" on specific cols
Category | Number
------------------------
Food | 3
Food | 4
------------------------
Subtotal | 7
------------------------
Drink | 10
Drink | 15
------------------------
Subtotal | 25
------------------------
Sum | 32 (grand total)
Since tableFilter allows sorting, the use case would be something like
""always show grandtotal for Number col. When the Category is sorted,
show subtotals (by Category ... or by whatever col is sorted and is
flagged as subtotal-able) for the Number col".
Would be rather sweet for financial reporting stuff, etc (especially
combined with a fixed-footer for grand totals and scrolling for the
tbody). If not via tableFilter, any other plugins that do something like
what I described?
TIA,
Jack
