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 /wiki/spaces/CXO/pages/2806776298 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 /wiki/spaces/CXO/pages/2806776298 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 coloring. | 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 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 |