Inserting Rows and Columns
You insert rows or columns into a grid to add content, such as data, formulas, text, and Notes to the grid. Types of rows and columns include:
-
Data—Members of dimensions that are retrieved from a database connection. The member in a data row or column defaults to the top-level member of the dimension.
Note:
A data segment is a row or column that retrieves data from a database. An expanded data segment is a row or column that can expand, so that the resulting grid expands to two or more rows or columns when viewed. Often, expanded data segments use functions such as Children Of or Descendants Of. A single data segment is a row or column that remains a single row or column when shown in the viewer.
A
#
symbol in the cell, row, or column indicates that it is a data cell, row, or column. -
Formula—Values based on formulas. Commonly used to calculate totals, averages, and variances on data rows or columns.
An
= #
symbol in the cell, row, or column indicates that it is a formula cell, row, or column.Formula row or column headings, which display the row number or column letter, display a symbol as an indicator.
-
Text—Text typed into the cells or returned dynamically through a text function.
Text rows, columns, or cells in grids do not contain symbols when added to a grid. They are initially blank until populated with text.
Note:
Text segments or cells do not support special characters such as superscript and subscript.
Text row or column headings, which display the row number or column letter, display a symbol as an indicator.
-
Separator—Inserts a blank row or column.
Separator rows do not contain data or text. They serve as a visual dividing line between rows or columns in a grid.
- Note - For Narrative Reporting deployments, you can insert a Note row or column into a grid for structured POV-based commentary entry. Note row or column headings, which display the row number or column letter, display a symbol as an indicator.
To insert a row or a column in a grid: