Applying Aggregate Functions in Composite Queries
To apply aggregate functions to the output field of composite queries:
Select Reporting Tools, Composite Query, Composite Query Manager.
Open an existing composite query or create a new one.
In the Composite Query Manager page - Fields section, select an aggregate option from the Aggregate drop-down list.
The available options are Average, Count, Count Distinct, Max, Min, and Sum.
Optionally, click the SQL button to verify the aggregate setting on the generated SQL.