|Monthly % Variances (2 files)
|Provides an analysis of the percentage variances between one file and another monthly as well as an annual percentage variance.
|Number of Files
|2 Summary Files required
|Can be applied to all Sales and P&L databases.
|Monthly Variances (2 files)
|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 percentage variances between values in two selected files per month for the full year, including the percentage variance value for the full year.
For information on how to import this Crosstab Definition please see How to Import a Crosstab Library File.