Subtotals of Grouped Rows - How To?
Subtotals of Grouped Rows - How To?
I've got a DataTable where my output is coming from a query, and I can easily enough generate the row containing the subtotal of the columns I'm grouping by in my query, but I lose the sortability client-side, in addition to the filter not picking up the subtotal row, pagination, etc.
Can someone provide an example of how to capture the total of a group of rows, then write in a row below with the subtotal of one or more columns? I'd like to leverage DataTables built in features rather than remove them in order to achieve subtotals. Thanks!
Can someone provide an example of how to capture the total of a group of rows, then write in a row below with the subtotal of one or more columns? I'd like to leverage DataTables built in features rather than remove them in order to achieve subtotals. Thanks!
This discussion has been closed.