Example
In this example we want to compare sales with orders for the last 3 months for a selection of customers.
- From the 'Sales' database select 'Ship to' dimension and select customers.
- Select Period > Last 3 months.
- Select Mode > Period stream, as shown below. An additional button will now appear to the right of the standard 'sales' stream button. In this example the additional stream 'orders' has been selected.
As shown below, the grid will display results for sales and orders, both as total and for each month. Variance is also displayed, as an amount and as a percentage.
Learn about how the variance is calculated
The values in the Variance column = (Current - Previous)
The values in the % Variance column = ((Current - Previous) / Previous) *100
The totals at the top of the Current, Previous and Variance columns are the sum of all the cells in their respective columns
The total at the top of the % Variance column = ((Total Current - Total Previous) / Total Previous) *100