# LAYOUT Layout functions can be used to set the layout, set a theme, enable/disable rails, or expand the hierarchy to a particular level. Let's take a look at the various options.

NAME	DESCRIPTION
LAYOUT.HIERARCHY	Sets the layout to hierarchy
LAYOUT.OUTLINE	Sets the layout to outline
LAYOUT.TABLE	Sets the layout to table
LAYOUT.STEPPED	Sets the layout to stepped
LAYOUT.DRILLDOWN	Sets the layout to drilldown
LAYOUT.LIGHTTHEME	Applies a light canvas
LAYOUT.DARKTHEME	Applies a dark canvas
LAYOUT.AUTOFIT	Fits the maximum possible data in the available space
LAYOUT.SETRULER	Enable or disable the ruler
LAYOUT.GOTOCOLUMNLEVEL	Expands the column hierarchy to the specified level
LAYOUT.GOTOROWLEVEL	Expands the row hierarchy to the specified level

## 1. LAYOUT.HIERARCHICAL Sets the layout option to hierarchy and displays the data in a hierarchical format. ### Syntax ```javascript LAYOUT.HIERARCHICAL ```

## 2. LAYOUT.OUTLINE Sets the layout option to outline. ### Syntax ```javascript LAYOUT.OUTLINE ```

## 3. LAYOUT.TABLE Sets the layout option to table. ### Syntax ```javascript LAYOUT.TABLE ```

## 4. LAYOUT.STEPPED Sets the layout option to stepped. ### Syntax ```javascript LAYOUT.STEPPED ```

## 5. LAYOUT.DRILLDOWN Sets the layout option to drilldown. ### Syntax ```javascript LAYOUT.DRILLDOWN ```

## 6. LAYOUT.LIGHTTHEME Sets a light background for the canvas. ### Syntax ```javascript LAYOUT.LIGHTTHEME ```

## 7. LAYOUT.DARKTHEME Sets a light background for the canvas. ### Syntax ```javascript LAYOUT.DARKTHEME ```

## 8. LAYOUT.AUTOFIT Fits the maximum possible data in the available space. ### Syntax ```javascript LAYOUT.AUTOFIT ```

## 9. LAYOUT.SETRULER Fits the maximum possible data in the available space. ### Syntax ```javascript LAYOUT.SETRULER(TRUE) #Enables the ruler LAYOUT.SETRULER(FALSE) #Disables the ruler LAYOUT.SETRULER(THIS) #Control the 'THIS' parameter using a toggle variable button ```

## 10. LAYOUT.GOTOCOLUMNLEVEL Expands the column hierarchy to the specified level. The highest level of the hierarchy is denoted by '0'. ### Syntax ``` LAYOUT.GOTOCOLUMNLEVEL(1) #Expands to the second level of the column hierarchy LAYOUT.GOTOCOLUMNLEVEL(THIS) #Expands to the specified level which can be set using a numerical stepper variable ```

## 11. LAYOUT.GOTOROWLEVEL Expands the row hierarchy to the specified level. The highest level of the hierarchy is denoted by '0'. ### Syntax ``` LAYOUT.GOTOROWLEVEL(2) #Expands to the third level of the column hierarchy LAYOUT.GOTOROWLEVEL(THIS) #Expands to the specified level which can be set using a numerical stepper variable ```

--- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.fabricplan.com/planning-sheets/formula-syntax/scripting-functions/layout.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.