To insert running totals and moving averages in a given field, use the Insert > Running Total and Insert > Moving Average commands for that field.
The displayed dialog box enables you to specify the source data field these values are calculated for and the following options:

• Running totals:

  • The initial value the total is set to
  • The total type: sum, difference or product
  • The range of the fields to processed: current selection, all currently filtered records, all records in the table

  

• Moving averages:

  • Weights - check this option to apply weights to data series values. The default "N...1" selection means that the latest value in the N-element period will have the weight equal to N and the oldest one: 1.
    You can specify your own weights as a column in some other tables. The number of weights should be equal to the size of the period and the first row corresponds to the latest period value. If the number of weights is smaller, the remaining (missing) weights are assumed to be 1. If it's greater - the last weights are ignored.
    
  • Period - the number of values each average is calculated for.
  • Shift - For the default 0 value, each period for each average ends in the row/record the average is inserted in and starts N rows/records above it. As there are no enough data for the initial N-1 averages, the corresponding fields will be filled with the #NULL! error values.
    Positive 'shift' values moves this compartment down/forward and negatives shift values - further up.
  • The range of the fields to processed: current selection, all currently filtered records, all records in the table