Depending on the list dimension chosen for a specific list, the first column(s) will be the dimension(s) which is chosen for each item. In the example above, that is the Account dimension.

List Attributes

Basic Attributes

List Attribute	Description	Available Values	Default
Empty	Empty lines will not be visible, if you set this attribute to yes.	No, Yes	No
Comment	n/a		No
Visible	By setting this attribute to no, the line will be hidden. Hiding an item can be useful for a calculation step in a formula.	Yes, No	Yes
Custom Description	The custom description overrides the default generated name. You can use either a fixed text or a Dynamic Label Expression	Empty, Populated	Empty
Formula	By specifying a formula this item will be calculated.	Empty, Populated	Empty
Format	The format can be used to override scaling and precision.	Default, Default_bold, Default_left, ...	Default Format
Order	Use the order attribute to reorder the items.	1, 2, 3, ...	Max + 1

Advanced Attributes

List Attribute	Description	Available Values	Default
Header Format	The header format defines how the column header should be formatted.	Default, Default_bold, Default_left, ...	Default
Reverse Valuation	When this attribute is set to yes, the Valuation will be reversed. This means negative becomes positive and the other way around. Changing the valuation will influence the variance colouring.	No, Yes	No
Reverse Sign	When this attribute is set to yes, the sign will be flipped.	No, Yes	No
Insert Data Label in Chart	When this attribute is set to yes, the data labels will be included into the chart	No, Yes	No
Variance Threshold	Threshold value for the Variance (e.g., Actual vs. Budget). If the Variance is less than this Threshold, then a neutral variance colour is used (Orange). Otherwise Red (indicating an unfavourable variance) or Green (favourable variance) is used. Use e.g. -200;300 for an absolute threshold or -10%;20% for a relative threshold.	Empty, Populated	Empty

5.4 Documentation

Pick List

Introduction

Example:

List Attributes

Basic Attributes

Advanced Attributes