Use this dialog to create a running total calculation. A running total calculation calculates the total starting with the first value in the group, adding each previous total value to the next value in the group. For example, you might want to calculate a cumulative total of sales figures.
This type of analysis is sometimes referred to as windowing.
For more information, see:
"What are analytic functions?"
"How to create a calculation using an analytic function template"
Use this drop down list to choose the item for which you want to calculate the running total. For example, you might choose Sales SUM to calculate a running total of sales values.
Use this drop down list to specify how to order the values. For example, you might choose Calendar Month if you want running total across months.
Use the adjacent drop down list to specify whether to order values in ascending order (that is, Lowest to Highest) or descending order (that is, Highest to Lowest).
Use this drop down list to specify a secondary order for the values. For example, you might choose Calendar Month from the Order rows by list and City from the Then order rows by list to sort values on city within month.
Use the adjacent drop down list to specify whether to order values in ascending order (that is, Lowest to Highest) or descending order (that is, Highest to Lowest).
Restart running total at each change in
Use this list to specify the groups to be used to arrange results into groups (sometimes referred to as partitions).
For example, to calculate a running total for Sales SUM values within year, you might choose Calendar Year here. In other words, if you have Sales SUM values spanning two years, you would have a running total for each year.
If you do not specify a group, Discoverer treats all worksheet values as a single group.
This read-only field displays the underlying formula that you are building as you specify values for the fields above. This formula is updated each time you change one of the values in the fields above. When you click OK, the formula is transferred to the Calculation field in the "New Calculation dialog" or the "Edit Calculation dialog".