Editing a Column Definition

    

icon_cptools_column_edit

"Edit column definition" button

 

Within the column view you can add new columns and edit or delete existing columns in the column editor. 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

image_Spaltendefinition_Spalte

 

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".

 

icon_Spalte_vorherige

Previous button

icon_Spalte_naechste

Next button

icon_Spalte_neu_links

New column left button

icon_Spalte_neu_rechts

New column right button

icon_Spalte_loeschen

Remove button

 

 

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 with the organisation specified

<<Data stream abbreviated>> inserts the name of the data stream or analysis row with the organisation specified, abbreviated

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

<<Organisation>> displays the selected organisation

 

Please note:

For all column types, you can enter any text or a combination of text and variables as the column header.

 

 

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.

 

 

Please note:

All global options refer to the organisation and time span settings defined for the table. To make an individual selection, turn off the "Global" switch and select the desired reference for the column.

 

Column type: Data stream

Data stream columns display the values of the selected organisation and data stream for the selected time span. 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.

 

image_cons_Spalteneditor_Datenebene

 

 

Column type: Analysis row

Analysis row columns display the absolute or relative values provided by the analysis type and the reference stream and comparison stream for the selected organisation. Under Display mode you can specify whether the values should be displayed as numbers, bars or a combination of the two. Select the time span and, if desired, define a year shift for the reference stream and/or the comparison stream.

 

image_cons_Spalteneditor_Analysereihe