> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.sigmacomputing.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server.

# Nth

> Use the Sigma Nth function to repeat the Nth value of the the given column for every row in a column.

The **Nth** function repeats the Nth value of the the given column for every row in a column.

This function isn't compatible with all data platform connections. To check if your connection supports it, see [Supported data platforms and feature compatibility](/docs/region-warehouse-and-feature-support#supported-data-platforms-and-feature-compatibility).

## Syntax

`Nth([Column], n)`

Function Arguments:

* **\[Column]** (required) - A column of text, numbers, or dates to analyze.
* **n** (required) - Offset from top of column. Must be a constant integer greater than 0.  

When there is no sort specified on the table, the results for this function can change if you refresh the workbook. The sort is different upon refresh.

## Example

`Nth([Quarter], 2)`

Returns the 2nd result in the \[Quarter] column for every row in the \[Nth] column.

![Table with a Quarter column with rows of Q1, Q2, Q3, and Q4. The Nth column lists Q2 as the value for all rows.](https://files.buildwithfern.com/sigma.docs.buildwithfern.com/b897fe37150fca7096cff6c92a773c3ba3bc7a6074a0060efc48124709b95916/assets/docs-images/cc2ab6f-9.png)

## Related resources

* [First](/docs/first)
* [Last](/docs/last)
* [FillDown](/docs/filldown)