|Crosstab Name||Comparison of 12 month Totals|
|Description||Analyses differences in actual/forecast data for previous/next 12 months.|
|Number of Files||3 Summary files required|
|Database Validity||Can be applied to all databases.|
|Extra Notes||Requires file 1 = PY Actual, file 2 = CY Forecast, file 3 = CY+1 Forecast.
Does not use any classification variables, so is applicable to all sales databases.
Selected period must be January to December.
Variance option must be Period Totals only.
You would like to analyse variances between actual and forecast values for the previous/next 12 months.
12 months totals = Sum of values for CM +1 to Dec + Sum of values from Jan - CM.
For example, if CY = 2013 and current month (CM) = 4 (April),
12 month total for actual = Sum May - Dec 2012 + Sum Jan - Apr 2013
For first item above, 12 month actual total = 69,500 + 41,615 = 111,115.
For information on how to import this Crosstab Definition into your database please see How to Import a Crosstab Library File.