Previous Topic

Next Topic

Book Contents

Book Index

Totals and Sub-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:

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:

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.

Advanced Query Tool
© 2023 Cardett Associates Ltd. All rights reserved.