View aggregate values

You can perform a numeric operation on data within a single column of the table by selecting the Aggregate button.

Note: Before you can use this function, the ColumnAggregateEnable custom property must be True.

You can perform the following functions on column data. Not all operations may be available for a column because of the data type.

• Average: Calculates the average number of items in the column.

• Count: Lists the number of rows in the column.

• Maximum: Lists the highest number in the column.

• Minimum: Lists the lowest number in the column.

• Sum: Adds the numbers in each row and provides a total.

To view aggregate values

1. Select Aggregate. The summation sign (S) appears at the head of each column.

2. Select the summation sign at the top of the OrderQty column. The Select Summaries dialog box appears.

   

3. Select Average and select OK. The value appears just below the Grand Summaries row. You can re-size the column width to view the entire number This following figure shows the average value for OrderQty.

   

4. To hide the Grand Summaries row follow these steps:

   1. Select the summation sign.

   2. Clear the Average check box in the Select Summaries dialog box

   3. Select OK.

5. To hide the summation signs, select Aggregate.