Sort Key Settings in Nodes
Nodes in a model tree do not sort alphabetically, and the default order rarely matches how a statement is read. Costs sorting above revenue is the usual complaint. A node’s sort key fixes it.
Goal
Put the nodes of a model tree in a deliberate order, so the tree reads the way your audience expects.
Prerequisites
- Edit rights on the model the nodes live in, since the setting is on the node rather than on the chart.
Steps
-
Open the model and select the node you want to move.
-
Click Show Advanced Settings.
-
Enter a sort key. The keys sort in ascending order, so give the node that should come first the lowest key.
In this example Revenue is given
A1and Costs is givenB2, which puts revenue above costs:
-
Repeat for the other nodes you want to place.
Verify
The model tree is sorted accordingly, with revenue above costs:

If nothing moved, check that you set the key on the node rather than in the chart, and that the keys you used actually sort in the intended order.
Related
- Model Tree: the chart type this order applies to.
- Advanced Node Settings: the other settings on a node, including hide in workspace.
- Sorting Level Values: ordering the values within a single chart, rather than the nodes across a model.