Line Groups and Line Items in Models (left) and Excel (right)
Line Items
All Variables, Assumptions and Metrics in your Layout are represented by a Line Item. As shown in the screenshot above, when a Variable or Metric has a Dimension applied (the Variable Gym members in the example), you only need to add a single item to the Layout for all child items, and the summary line, to be generated in the Excel.
Line Groups
Each Line Item must be a child of a Line Group. Line Groups can be added to other Line Groups in a tree-like structure, and numbering will be automatically added, as in the example screenshots above.
Dashboards
Dashboard Sheets contain a reference to a single Dashboard. In the Sheet wizard, if you select the Dashboard Sheet type, you will be shown a step in which you can choose a Dashboard to display. Only one Dashboard can be shown on any single Sheet.
