|Crosstab Name||Monthly Variances (2 files)|
|Description||Provides an analysis of the variances between one file and another monthly as well as an annual variance.|
|Number of Files||2 Summary Files required|
|Database Validity||Can be applied to all Sales and P&L databases.|
|Variants||Monthly % Variances (2 files)|
|Extra Notes||Variances shown are for file 1 vs file 2 (base), hence the sequence of files is significant.
Does not use any classification variables, so is applicable to all sales and P&L databases.
Period must be January to December.
Variance option must be Period Totals only.
You wish to show simple variances between values in two selected files per month for the full year, including the variance value for the full year.
For information on how to import this Crosstab Definition please see How to Import a Crosstab Library File.