Displaying summary statistics in footers

Updated in 8.5

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 statistics:

Statistic name Explanation Field types the statistic is available for

Min

The smallest value

Date/time, Numeric, Duration, Currency

Max

The largest value

Date/time, Numeric, Duration, Currency

Count

The total number of records

All

Average

The average of the values

Date/time, Numeric, Duration, Currency

Sum

The sum of the values

Numeric, Duration, Currency

You can configure displaying summary statistics either directly in the grid or using the Summary tab of the Customize View window. Before you begin, 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. Right-click anywhere in the grid and choose Customize View from the pop-up menu.

  2. In the Customize View window, 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.

  3. Configure displaying statistics by using the following methods:

    • To show statistics for a field, double-click the desired field click the desired field , then click Add 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, click the field in the unnamed pane, then click Remove.

    • 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.