Configuring Lists, Charts, and Filters › How to Configure a List › Add an Aggregation Row for a Number Field to a List Portlet

Add an Aggregation Row for a Number Field to a List Portlet

An aggregation row shows statistical data for money or number fields that display in the aggregation row. You can choose from a number of mathematical functions to apply to the individual fields you select for the row. You can choose maximum, minimum, average, sum, count, standard deviation, and variance.

Follow these steps:

1. Open the List Column Section menu, and click Aggregation.

   The list aggregation page appears.

2. Click Add.

   The properties page appears.

3. Complete the following fields:

   Label

   Defines the name for the aggregation row. Enter the name you want to appear.

   Show

   Determines whether the name of the aggregation row is displayed. Select the check box to display the name.

   Attribute

   Specifies the field value that is to be used for aggregation. All fields that you have selected for the grid portlet are present for selection but do not have to be included in the aggregation row.

   Function

   Specifies the aggregation function used to calculate values for a selected field (cell) in the row.

4. Save the changes.

More information:

How to Configure a List

Display an Aggregation Field as a Bar or Column Graph