Crosstabulation Definition Column Headers

Overview

Columns can be given individual headers based on the text entered, or a label taken from specific information within the database. To access column headers select a column in the Crosstab Definition and select Properties > Column Headers tab.

Creating the Header

By selecting the arrow beside the column header box, IFP opens a list of all the shortcuts available. Choosing CM~ (as above) will create the short name for the current system environment month e.g. Feb in the report. Below this the customer (Wholesaler1) is shown, this has been entered by the user. 

The shortcuts available are as follows:

• CM~ Current system environment month short name; e.g. Feb
• PM~ Current system environment month -1 e.g. Jan
• RM~ Current system environment month +1 e.g. Mar
• DD~ Day number for current system environment month
• MD~ Cumulative day number for year
• AD~ Total annual days for current year
• CD~ Day number in format 'Day DD'
• CL~ Day label for current day of current system environment month
• RY~ Remaining days for current system environment month
• TD~ Total days for current system environment month
• YD~ Total days for current month for year corresponding to column
• F1~ File 1 label.

If one line of the column header is identical in one or more adjacent columns, those column headers will be merged, shown by Units in the example below.

You can still have the same column header in consecutive columns without merging by inserting a space at the end of the required text in alternate columns as shown by Variance in the example below.

Note:
Column codes can also be constructed in Excel and copied and pasted into the Crosstab Definition Editor. This can be more efficient than making individual manual selections.

File Labels

Column headers can also contain file labels, this can be done using the F1~ shortcut, this will use the label from the first file as the header. To use a different file as the base for the column header change the number following F. e.g. for the column header to contain the label for File 3, enter the shortcut as F3~.

In the example below, the header is the label of the first data file (11 Plan).