Example:
List Attributes
Basic Attributes
List Attribute | Description | Available Values | Default |
|---|---|---|---|
Empty | Empty tree members are not shown on the value tree. | No, Yes | No |
Visible | By setting this attribute to no, the tree member will be hidden. Hiding a tree member 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 tree member will be calculated. | Empty, Populated | Empty |
Format | The /wiki/spaces/CXO/pages/2806776298 will specify the look and feel of the tree member. | Default, Default_bold, Default_left, ... | Default Format |
X Coordinate | The X coordinate defines the position of the tree member on the X Axis, see screenshot for the X positions. | 0, 1, 2, 3, ... | 0 |
Y Coordinate | The Y coordinate defines the position of the tree member on the Y Axis, see screenshot for the Y positions. | 0, 1, 2, 3, ... | 0 |
Unary Operator | The unary operator defines the symbol (See screenshot) in front of each tree member. | +, -, /, * | + |
Parent Item | Select a /wiki/spaces/CXO/pages/2806776443 so that the tree member will be connected with a line to the parent tree member. | Empty, Populated | Empty |
Order | Use the order attribute to reorder the rows. | 1, 2, 3, ... | Max + 1 |
Advanced Attributes
List Attribute | Description | Available Values | Default |
|---|---|---|---|
Header Format | The /wiki/spaces/CXO/pages/2806776298 will specify the look and feel of the tree member header. | Default, Default_bold, Default_left, ... | Default Format |
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 |
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 |
Redirect Report Name | Use this field to select one of the existing reports that will be available trough a hyperlink. | Empty, Populated | Empty |
Note: When you redirect to a report of type Multi-Column and that report has the same Value Tree List as an Item Selector, the Multi-Column report will automatically select the tree member where it was redirected from.