Editing a Column Definition

In the column editor you can add new columns and edit or delete existing columns. To open the column editor for a particular column, right-click that column and then click "Edit". The following options are available, some of which depend on the column type:

Selecting a column

Select the column you wish to edit in the list or by using the "previous" or "next" buttons. To create a new column next to the selected column, click the "New column left" or the "New column right" button as desired. To delete the selected column, click "remove".

Column headers

Depending on the column type (see below), you can define the column header by selecting the following variables from the list:

<<Data stream>> inserts the name of the data stream or analysis row

<<Business year>> displays the current business year (e.g. "2019")

<<Business year, abbreviated>> displays the short form of the current business year (e.g. "19")

<<Time span>> active time span (e.g. "January - December 2019")

<<Time span, months>> active time span, months only (e.g. "January - December")

<<Time span, months, abbreviated>> active time span, months only in short form (e.g. "Jan - Dec")

<<Date>> displays the current date (e.g. "01/08/2019")

<<Time>> displays the current time (e.g. "1:16 PM")

<<Report name>> displays the saved report name

<<File name>> name of the data source

<<User name>> name of the current user

<<Field property>> displays the selected field property

<<Column>> displays the column number

<<Sum sign>> displays the sum sign

<<Average sign>> displays the average sign

<<Delta sign>> displays the delta sign

Currencies

If more than one currency has been defined for the underlying data source, you can display the values of each column in one of the available currencies.

The available options for defining the columns vary according to the table type or analysis. The following column types exist:

Column type: Data stream

Data stream columns display the values of the selected data stream and time span for the selected measures. Under Display mode you can specify whether the values should be displayed as numbers, bars or a combination of the two. If you wish, you can also define a time shift. The "Display zero column" option also displays columns that contain only zero values.

Column type: Analysis row

Analysis row columns display the absolute or relative values of the selected measures and time span provided by the analysis type and the reference stream and comparison stream. Under Display mode you can specify whether the values should be displayed as numbers, bars or a combination of the two. If desired, define a time shift for the reference stream and/or the comparison stream. The "Display zero column" option also displays columns that contain only zero values.

Column type: "Field property"

This column type displays the field name.