TABLE

Format the data in your cells with the TABLE, TABELROW, and TABLECELL functions. The TABLEROW function creates a row, and the TABLECELL function creates a column within a row.

Syntax

TABLE(
 TABLEROW(
   TABLECELL([Measure1]) 
   )
)

Arguments

measure - Pass the measure to be displayed.

Example

TABLE(
	TABLEROW(TABLECELL("Row1 Cell1")
     ),
     TABLEROW("This is a blank row"),
    TABLEROW("This is Row2")
)
//Returns 
Row1 Cell1
This is a blank row
This is Row2

In this report, we've used the TABLE functions to concatenate the data from different measures and format them within a single cell.

Using the TABLE functions to format data