Inserting Rows and Columns
You insert rows or columns into a grid to add data 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.
A # symbol indicates data rows, columns, or cells.
-
Formula—Values based on formulas. Commonly used to calculate totals, averages, and variances on data rows or columns.
An = # symbol indicates formula rows, columns, or cells.
-
Text—Text typed into the cells or added 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.
When you add a grid to a report, it contains one of each of the following:
-
Data row
-
Anchor row
-
Data column
-
Anchor column
An anchor row or column is a blank row or column located at the end of the rows or columns. You can add one or more rows or columns in a grid, or you can use the anchor row and column to append new rows and columns.
To insert a row or a column in a grid: