Assign an Aggregate Function to a Column

Use the Select Columns pane on the Account Analysis page to assign an aggregate function to a column. When you run the query, the aggregated values appear in the column instead of the actual value. Non-aggregated columns create the groups represented by the aggregated data.

To assign an aggregate function to a column

1. Ensure that a query is open on the Account Analysis page.

2. In the Select Columns pane, click the column and then click fx Aggregate.  

3. In the list box, click a function. The original column name appears with the aggregate function name appended. For example, if you selected the "average" function for the Current Balance column, the Current Balance column name changes to Average of Current Balance.

4. To delete an aggregated function, click the aggregated column name, click fx Aggregate, and then, in the list box, click Remove Aggregate. The original column name replaces the aggregated column name.

Related Topics

Aggregate Functions

Account Analysis