This article describes how to go from a standard table...
...to a table with an additional row that sums all the values in that column:
Requirements
A table with multiple rows.
Method
- Select your table.
- Go to Data (or Appearance) > Rules in the object inspector.
- To apply the rule, select the Plus (+) > Table Computations > Naive Total For Each Column.
- Change the New row label as required.
- Set the Position to place the new column on the top or bottom.
- Press OK.
This rule then adds a new row at the bottom of the table which contains a total for each column. The total is calculated by adding up all of the statistic values in that column, and excludes any rows that are duplicates of other rows in the table (e.g. NETs).
Note the following:
- Statistical tests are not performed on these cells.
- Any statistic shown on the table will be added up and included in the total, however be aware that for some statistics it may not be meaningful to display a naive total.
- If you select Switch rows and columns on your table, the rule will no longer work due to the table dimensions changing. In this case, you will have to apply the Naive Total For Each Row rule instead.