Calculate a Running Total

You can include a column or row in your report that shows a running total. The running total can be expressed as a numeric or percentage value. In Reporter reports, you can calculate a running total for more than one category.

For example, you create a report that shows the revenue in each of the past four quarters. The running total shows the total revenue by the end of each quarter. If you add a running total as a percentage of the total sold, you can see the percentage of the full year's sales achieved by the end of the quarter.

You can delete the category representing the base value from the report after creating the cumulative percent of base value.

In Explorer mode, you can select only one category on which to perform a running total as a numeric or cumulative percent of base value.

You cannot perform a cumulative percent of base calculation on a rank category.

Note: In Reporter mode, if the selected category includes an existing calculation the calculation value is included in the running total.