In the designer, you can use the design-time row, column, and cell to reference the calculated rows, columns, or cells.
The syntax for row or column is:
AXIS[Segment(Range)].Property
CELL[Row Segment(Range), Column Segment(Range)].Property
A row or column containing the expanded cells identified by the given row and column templates. The default is row. For example, [3] refers to row 3 and [C] refers to column C. The following reference: [3].sum in a column formula is calculated as the sum of row 3. | |
The intersection of the expanded cells, given the row and column template coordinates, respectively. For example, the following reference: [2,C] is the single cell where row 2 intersects column C. | |
A value that represents a row or column ID in the designer. Referenced segments refer to design-time rows or columns, which might 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 using segments, see Expressing the Segment Argument. | |
The 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 Conditional Suppression and Sorting Rows, Columns, and Pages. 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 using ranges, see Expressing the Range Argument. | |
Optional. A function applied to aggregate rows, columns, or cells. For more information on using properties, See Aggregate Property Arguments. |