Set Instructions

Set instructions are built-in operations you apply to a dimension set to control how its members are selected, ordered, formatted and displayed within a Workview. They let you shape a set declaratively - sorting and grouping members, applying number formats and styles, suppressing empty rows, inserting calculated members, and more - without changing the underlying data.

Each set instruction is listed in the sidebar, organised into categories:

• Set Formatting - control indentation, expansion, drill-down and the position of subtotals.
• Set Manipulation - sort, group, and remove members within the set.
• Data Formatting - apply number formats to the values displayed in the set.
• Advanced Functions - formula-driven labels and styles, header and cell styling, element insertion, variance calculations, and suppression.

The documentation for each instruction includes its purpose, usage and related help content, making it easy to learn how to use each one effectively.