The general syntax for referencing cells in a cross table is: cells(x coordinate, y coordinate, measure#). The x coordinate refer to columns, while the y coordinate refer to rows. The measure reference is necessary since there may be more than one measure in a cross tab object.
The current column or row can be referenced by replacing the x-coordinate or y-coordinate respectively with '0'.
For example:
§ If a calculated column has been
added, the current row can be referenced as
cells(x coordinate, 0, measure#)
§ If a calculated row has been
added, the current column can be referenced as
cells(0, y coordinate, measure#)
In addition, a shorthand notation exists that such that:
§ Column cells in the current row
may also be referenced as
cols(x coordinate,
measure#)
§ Row cells in the current column
may likewise be referenced as:
rows(y
coordinate, measure#)