How to Add a Naive Total For Each Column in a Table

Introduction

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

1. Select your table.

2. Go to Properties > RULES on the object inspector.

3. To apply the rule, select the Plus (+) > Browse Online Library > Table Computations > Naive Total For Each Column.

4. Change the New row label as required.

5. Set the Position to place the new column on the top or bottom. 

6. 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, 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.

See Also

How to Use Rules in Displayr