|Crosstab Name||Month & YTD Variance Analysis by Unit and Value|
|Description||Shows variance and percentage variance between file 1 and file 2 for both Units and Value for the current month and YTD.|
|Number of Files||2 Summary files to be used|
|Database Validity||Can be applied to all Sales databases.|
|Variants||Analysis by Unit and Value Variance Analysis by Unit and Value|
|Extra Notes||Variances shown are for file 1 vs file 2, hence the sequence of files is significant.
Does not use any classification variables, so is applicable to all sales databases.
Period must be January to December.
Variance option must be Period Totals only.
This definition is created by setting an advanced property that uses a specified data type for relevant columns.
You would like to see how the actual figures are doing compared to the planned figures for the last completed month (April), as well as for the year so far. You want to see this both in the number of units sold and the value of each item.
For information on how to import this Crosstab Definition please see How to Import a Crosstab Library File.