Moving Total

A report moving total column outputs a running total of the values in the specified column.

The totals are calculated for the current row, and a number of preceding rows determined by the number of data points you select. By default, the report moving total calculation uses three data points. For example, if you had a column with four rows, with values of 10, 20, 30, and 40, respectively, and used three data points, the corresponding values in the report moving total column would be NULL, NULL, 60, and 90.