Crosstab Name | Comparing 4 Month Cycles Between Years (3 files) |
Description | Compares 4 month cycles between two or more years, this shows how to compare such cycles for any 3 selected files. |
Number of Files | 3 Summary files required |
Database Validity | Can be applied to all Sales and P&L databases. |
Variants | Can be generated from this crosstabulation definition for 2 files + |
Extra Notes | Requires files in time order e.g file 1 = PY, file 2 = CY, file 3 = CY+1. 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. |
Example
You would like to compare last years Actuals, the Current years Working Forecast and Next Years forecast over the 4 month cycle of the calendar year.
It is easy to enhance this example to deal with any number of files for any length of cycle by adjusting this Crosstabulation Definition with regards to the Period Lengths used and the number of files used for each period.
Download
For information on how to import this Crosstab Definition into your database please see How to Import a Crosstab Library File.
Comments
0 comments
Please sign in to leave a comment.