You can use formulas to reference rows, columns or cells from another grid to combine content from multiple grids into one. This can be used to pull together content from different data sources, sourced in one or more grids, into a single grid. The source grids for the formulas can exist in the hidden sheet, so they are not displayed in the report output.
The formula syntax is as follows:
<grid> - is the name of the grid you are referring to. If the grid name has a space in it, surround the grid name in quotes. For example:
<reference> - is the reference to the row, column or cell, surrounded by square brackets. For example
[b]  [b,1].
The report contains three grids: “
Grid 1” contains formulas referring to other hidden grids, “
Grid 2” and “
Grid 1 contains few formulas in it. For example: The grid contains a row, column and cell formula:
Column C column formula: “Grid 2”.[a] refers to Grid 2, column A
Cell D2 cell formula: “Grid 2”.[a,2] refers to Grid 2, cell A2
Row 4 row formula: “Grid 3”. refers to Grid 3, row 1