Displaying summary statistics in footers

You can configure to display summary statistics for the whole grid and, if the records are grouped, for groups or records. The statistics will be shown in the grid and group footers respectively. The following table lists the available summary functions:

Name of statistics Explanation Types of fields the statistic is available for

Min

The smallest value.

Date/time, Numeric, or Currency

Max

The largest value.

Date/time, Numeric, or Currency

Count

The total number of records.

All

Average

The average of the values.

Date/time, Numeric, or Currency

Sum

The sum of the values.

Numeric or Currency

You can choose summary functions to show statistics either directly in the grid or on the Summary tab of the Customize View window.

Before configuring statistics to show, make sure the relevant footers (either grid or group ones or both) are enabled. For instructions, see Showing and hiding footers.

To choose statistics for the whole grid directly in the grid:

  • Right-click on a grid footer in a column corresponding to the desired field and select the statistics to show from the pop-up menu.

To choose statistics for groups directly in the grid:

  • Right-click on any group footer in a column corresponding to the desired field and select the statistics to show from the pop-up menu.

To hide statistics for grid or groups directly in the grid:

  • Right-click on the displayed statistics in the grid or the group footer correspondingly and select None from the pop-up menu.

To configure showing record statistics in the Customize View window:

  1. Click View > Customize View on the main menu to open the Customize View window and click the Summary tab. The Define Summary for These Fields pane shows the fields for which some statistics are shown and the kind of statistics. The Available Fields pane lists the rest of the visible fields.

  2. Configure displaying statistics by using the following methods:

    • To show statistics for a field, double-click the desired field in the Available Fields pane. Choose the desired summary function for the grid and group footers in the Footer and Group Footer columns correspondingly.

    • To hide all statistics for a field, double-click this field in the Define Summary for These Fields pane.

    • To hide statistics either in the grid or group footer, select None in the Footer or Group Footer column correspondingly (the None option is available when the other column does not contain None).

    • To hide all statistics, click Remove All.

  1. Click OK.