How to Create a Crosstabulation Column

The Column Definitions tab in the Crosstabulation Definition Editor allows you to create and edit the columns required to create the definition.

Each column within the Crosstabulation Definition Editor represents the make up of each row in the definition itself. Each column has the following settings:

Sign

This determines whether the column contains positive or negative values in the report output. Positive values are given to the items that are sold and generate an income. Negative values are given to outgoings or costs to the business.

Column

This allows you to define which column this item will be output into. By default, output columns are numbered 1 to n (where n is the number of columns defined).  

Column Type

Allows you to choose which column type to display in the required data. There are a large number of these to suit all types of definition you may want to create.

Column Code

This allows you to define the data that is used in the column, built using the column type you have selected. See specific column codes for more information.

Column Header

This allows you to define an optional column header which will be displayed on report output. See column headers for more information.

How to Add a Column

Click Add to create a new column at the end of the definition. To insert before the current column, click the drop-down arrow and select Insert Before. Move through the selections above to create a complete definition.

Deleting a Column

To delete a column that is no longer required, select it and press Delete on the toolbar. Make sure that you definitely want to delete this column as this process is irreversible.

Column Properties

By selecting a column and pressing Properties, you will be able to view the Structure of that column and apply any advanced options required to it.

Copy and Paste Columns

Single and multiple columns can be copied and pasted within a Crosstab Definition by selecting the column/s and right-clicking on the mouse.

Moving Columns

Single columns can be moved up and down within a Crosstab Definition using the up and down arrows to the right of the column definition table.

Be aware that you might need to revise any custom output column numbers after moving columns.