Hello,
Is there some way to add a “totals” row to the datatable? E.g., let’s say, I am displaying the number of flies in different rooms of a house:
| Room | Fly count |
|---|---|
| Living room | 1 |
| Dining room | 3 |
| Bedroom | 0 |
What I would like to do is add a “totals” row (which I am happy to provide data for myself—there is no need for magical aggregators doing any magic) that would looks like this:
| Room | Fly count |
|---|---|
| Total | 4 |
| Living room | 1 |
| Dining room | 3 |
| Bedroom | 0 |
What makes this row special is that it is:
- excluded from sorting and
- perhaps styled differently, e.g. like a second header row.
I think I can do the styling myself, but I do not know how to exclude the row from sorting. Any advice?
Thank you,
Denis.