Expanding Rows and Columns

You can use the design-time row, column, and cell to reference the calculated rows, columns, or cells.

Row or Column Syntax:

AXIS[Segment(Range)].Property

Cell Syntax:

CELL[Row Segment(Range), Column Segment(Range)].Property

Parameters:

Parameter	Description
`AXIS`	Row or column containing the expanded cells identified by the row and column templates. For example, [3] refers to row 3 and [C] refers to column C. For example,`[3].sum` in a column formula is calculated as the sum of row 3. The default is row.
`CELL`	Intersection of the expanded cells, given the row and column template coordinates, respectively. For example, `[2,C]` is the single cell where row 2 intersects column C.
`Segment`	Value that represents a row or column ID in the Report Designer. Referenced segments refer to design-time rows or columns, which can expand in the viewer. View-time rows and columns are the expanded rows and columns. Use numbers for row IDs and letters for column IDs. Note: If you are using an expanded formula row, the default segment is row. If you are using an expanded formula column, the default segment is column. For example, row [ 5 ] refers to expanded row 5. For more information on segments, see Expressing the Segment Argument.
`Range`	Expanded cells used in the calculation of the function. Range refers to view-time expanded rows and columns. Calculations are performed after suppression. Sorting is performed after calculations. For more information on sorting and suppression, see Using Conditional Suppression and Sorting Rows, Columns, or Pages in Grids. Use colons to refer to a range of expanded rows or columns. For example, `(3:6)` addresses rows 3, 4, 5, and 6. For more information on ranges, see Expressing the Range Argument.
`Property`	Function applied to aggregate rows, columns, or cells. For more information on using properties, See Aggregate Property Arguments.