All reports in IFP may be produced with column definitions for each combination of report style and data options. Altogether, these combinations provide reports with a huge range of column definitions.
For more information, see How to Create a Crosstabulation Definition.
Example without Crosstabulation Definition
Columns in the report below are automatically defined from the report style (File Summary Report) with the selected files and variance option (Totals and % Variance vs. Previous file).
However, for some reports you may want to specify another sequence of columns and an alternative set of calculations. You may also wish to specify which items should belong to each column in the report. Finally, you may also want to include data on external variables such as market size or headcount.
In order to tailor reports to produce such features, you may create crosstabulation definitions that determine the contents, format and description of each column of each report for which that definition is used. Crosstabulation definitions are maintained using the Crosstabulation Definition Manager.
Example using Crosstabulation Definition
In the example below, columns have been defined for each of the business units included in the database, using the classification variable ‘BU’.
Crosstabulation definitions may also be used to include data on external variables such as headcount, market size and competitor sales. Part of an example report is shown below.