When designing a formula with a reference to a
specific cell, the syntax must be:
cells(d#, d#,
m#).
Note: Column and Row references have been prefixed with a: 'd', for “dimension reference”, while 'm' is for “measure reference”.
The dimension reference 'd' must be followed by either a positive or a negative integer which defines the referenced column’s or row’s position in the table.
§ Positive integers indicate that the table columns and rows are referenced from left to right and from top to bottom respectively (e.g., cells(d1,d1,m1) refers to the upper left cell in the table).
§ Negative integers indicate that the table columns and rows are referenced from right to left and from bottom to top respectively (e.g., cells(d-1,d-1,m1) refers to the lower right cell in the table).
Note: Please observe that calculated columns and rows are not
counted
when using 'd-1'.
The measure reference 'm' must be followed by a positive or negative integer which defines the measure’s position in the table.
§ Positive integers indicate that the measures are referenced from left to right or from top to bottom.
§ Negative integers indicate that the measures are referenced from right to left or from bottom to top (e.g., 'm1' refers to the leftmost or topmost measure and likewise 'm-1' refers to the rightmost or bottommost measure, independent of type, calculated or not.
The calculation reference 'c' can be used to refer to a previously
inserted, calculated column or row, and follow the same referencing rules as
measure references
(e.g., cells(c1,d1,m1) refers to the first
calculated column, while cells(d1,c1,m1) refers to the first calculated
row).