|Crosstab Name||Month & YTD Variance Analysis (3 Files)|
|Description||Provides an analysis of Monthly and YTD variances between one file and two others. The resulting report uses natural variance signs, i.e. Variance = File 1 - (File 2 or File 3).|
|Number of Files||3 Summary Files required|
|Database Validity||Can be applied to all Sales and P&L databases.|
|Variants||Month & YTD Variance Analysis (2 Files) Month & YTD Variance Analysis (4 files)|
|Extra Notes||Variances shown are for file 1 vs file 2 or 3, 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.
You want to show just the difference between the first file and the two other selected files, rather than financially which may show the opposite sign. You want this to be shown for the current month and YTD.
For information on how to import this Crosstab Definition please see How to Import a Crosstab Library File.