Example of period stream mode
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.
In period stream mode an additional button appears to the right of the standard 'sales' stream button. In the example below, 'orders' is the additional stream.
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.
Note about custom mode columns in period stream mode
When you are in period stream mode the column headings in the custom mode window show the 'grouping' title first, followed by the individual column title, separate by a 'pipe' character (in the screenshot below, an example is 'Total|Sales' in the first row in the window). Note that if you are changing the title for the 'grouping' you need to change it for all the columns that are in that group.
How these columns appear in the grid:
Only one measure can be used in period stream mode