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 | Default | DescriptionDescription | Available Values | Default |
|---|---|---|---|---|
EmptyNo | Empty lines will not be visible, if you set this attribute to yes. | CommentNo, Yes | No | |
| Comment | n/a | No | ||
Visible | Yes | 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 DescriptionEmpty | The custom description overrides the default generated name. You can use either a fixed text or a Dynamic Label Expression | FormulaEmpty, Populated | Empty | |
Formula | By specifying a formula this item will be calculated. | FormatEmpty, Populated | Empty | |
Default Format | The /wiki/spaces/CXO/pages/2806776298 can be used to override scaling and precision. | Default, Default_bold, Default_left, ... | Default Format | |
Order | Max + 1 | Use the order attribute to reorder the items. | 1, 2, 3, ... | Max + 1 |
Advanced Attributes
List Attribute | Default | DescriptionDescription | Available Values | Default |
|---|---|---|---|---|
Header Format | Default | The header /wiki/spaces/CXO/pages/2806776298 defines how the column header should be formatted. | Default, Default_bold, Default_left, ... | Default |
Reverse Valuation | No | 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 coloring. | No, Yes | No |
Reverse Sign | No | When this attribute is set to yes, the sign will be flipped. | No, Yes | No |
Insert Data Label in ChartNo | When this attribute is set to yes, the data labels will be included into the chart | No, Yes | No | |
Variance Threshold | Empty | Threshold value for the Variance (e.g., Actual vs. Budget). If the Variance is less than this Threshold, then a neutral variance color is used (Orange). Otherwise Red (indicating an unfavorable variance) or Green (favorable variance) is used. Use e.g. -200;300 for an absolute threshold or -10%;20% for a relative threshold. | Empty, Populated | Empty |