|Crosstab Name||Variance Analysis in Units and Values|
|Description||Shows variance and percentage variance between file 1 and file 2 for both Units and Value.|
|Number of Files||2 Summary files required.|
|Database Validity||Can be applied to all Sales databases.|
|Variants||Analysis by Unit and Value Month & YTD 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.
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 compare two files including variance and percentage variances in terms of both units and their value.
For information on how to import this Crosstab Definition please see How to Import a Crosstab Library File.