Note that 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, then uses a double-height header. The upper header displays the periods, the lower headers display current, previous, variance and % variance for each period. This mode is effectively a combination of period and variance modes.
Insert excerpt Use Variance mode Use 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 'Intercast'). 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 Intercast's results for the current month (June 2019 with the previous month (May 2019). The % variance between the months is displayed as a column.
| Info |
|---|
Only one measure can be used in period variance mode |