Note that stream period variance mode is not always enabled and can only be turned on by an advanced administrator with permission .
How the grid appears in this mode
The grid displays a column for all active properties in the current dimension, plus a column for current period and previous period. Variance and percentage variance columns are also displayed.
Insert excerpt Variance mode Variance mode nopanel true
Example
In this example we want to look at a customer's spending for the current month, compared with the previous month. We want to see the sales figures and also view the variance as a percentage.
- From the 'Sales' database select 'Ship to' dimension and select a customer (in this example, we have selected 'Autograph Advertising'). Focus on that customer.
- Select Period > Current month.
- Select Mode > Period variance, as shown below.
The grid will update, as shown below, and you can now compare Autograph Advertising's results for the current month (March 2015) with the previous month (February 2015). The % variance between the months is displayed as a column.