Simple and Cumulative Aggregates
Aggregates can be simple or cumulative.
A simple aggregate is determined by the type of footer in which you specify it. For example:
• If you specify the sum aggregate for the budget column in a report footer, then the aggregate contains the sum of the values in the budget column for all rows in the report.
• If you specify the sum aggregate for the budget column in the page footer, the aggregate contains the sum of the values in the budget column for the rows printed on each page of the report.
• If you specify the sum aggregate for the budget column in the break footer for the Department column, the aggregate contains the sum of the values in the budget column for all rows in each department.
A cumulative aggregate is a running total. It contains the aggregate of all the rows processed since the start of the report and does not depend on the location of the aggregate.