When displaying data in a table, we have the ability to subtotal certain rows within a column, which is good. I would also, however, like to be able to subtotal and total across all columns in a row. For example, if I have a table that shows students by grade, with columns by gender, I would like to see a total column at the far right that tells me the total number of Grade 9 Boarding students, Grade 9 Day Students, Grade 9 Students.
Gender |
||||||
Grade |
Female |
Male |
Other |
Unknown |
Total |
|
9 |
Boarding |
42 |
46 |
1 |
-- |
89 |
Day |
73 |
55 |
1 |
-- |
129 |
|
Sum |
115 |
101 |
2 |
218 |
You can do this by adding another column that is a calculation with the total number of the female and male students by grade.