Add column for total to Insight Designer

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




  • Guest
  • Mar 25 2021
  • Attach files
  • Kathleen Sanders commented
    March 26, 2021 21:13

    You can do this by adding another column that is a calculation with the total number of the female and male students by grade.