In Period mode, the first column after the Properties column(s) shows the total value for the selected period. This makes sense for streams that have cumulative data, such as Sales Invoices but in streams that hold a snapshot of data showing the variance over time, such as Stock on Hand, the total is meaningless. For these types of streams, you can display the period total as an average, rather than a sum of the periods.
For example, in the image below, the Total Value column displays the cumulative value of three month's worth of sales. This is the typical (default) view.
When you click Options > Totals as Average, that ‘total’ column now displays the average of those sales, which is reflected in the new column header. Note that the values in the TOTAL row of the period columns are not changed, just the values in the ‘total’ column.
