Variance Analysis in Units and Values

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.

Example

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.