Totals and Sub-totals

Totals

You can get totals of your columns by clicking on the Totals button, View > Totals or Ctrl+T.

You do not need to specify which columns are to be totalled - AQT will do this for all numeric columns in your data. This function is fast when your data has many numeric columns; the disadvantage is that it may total columns which are not meaningful to total (such as part numbers etc).

In addition:

• as you select a range of cells, if they contain any numeric values, the total will be displayed in the status-bar at the bottom of the window

Sub Totals

Once your data has been grouped (as described in Analyse data by grouping columns), you can display sub-totals and other calculations on the groups. You do this with (from the Data Display window) Tools > Group Calculations (Ctrl+K).

The Group Calculations window allows you to display a number of different statistics. These will appear in either the Group Header or Group Footer of the display grouping.

The values appearing in the Group Header will be visible when the display grouping has been collapsed - it can be useful to have some statistics displayed in this.

The Group Calculations window shows you all the columns in the table:

• check a statistic (Min, Max, Count) if you want that statistics calculated.
• for numeric columns, the Sum and Avg boxes will also be enabled.
• by default, the statistic will be shown in the Group Footer. Check the Show in Header? box if you want the statistic shown in the Group Header.
• as you select statistics, sample text will be shown in the Header and Footer boxes. You can amend this text if required.

Once you have created some group calculations, and have set up the data display in the way you want, you can save the layout with View > Save Layout. When you save the layout, this includes grouping and group calculations. This layout can be re-applied to the table at a later time. For more on this, see Saving / retrieving the display Layout.

Use Correct Data Types for Grid Columns

In order for both these functions to work, you need to set Options > Display Options > Use Correct Data Types for Grid Columns.

When this option is set, numeric columns are defined to the grid as being numeric. When the option is not set, all grid-columns are defined as character. Totalling and sub-totalling only works when the grid-columns are numeric.