> 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.

# Limit displayed values in a data element

> Limit which values display for a column in Sigma grouped tables, pivot tables, or charts to focus on top results.

You can limit which values are displayed for a column in a grouped table, pivot table, or chart.

For example, to only show the top 3 performing stores in each store region in a pivot table, you can limit the displayed stores to the top 3 sorted by total products sold:

![Pivot table showing Store region and store name columns with total quantity sold values. The Store name column is limited to the top 3 stores by total quantity sold, with the remainder showing as Others. Totals are hidden for the table.](https://fdr-prod-docs-files-public.s3.us-east-1.amazonaws.com/sigma.docs.buildwithfern.com/ca3c178a3a8517ed4b159062bf91622a170e23584f2592a637b2adab22f1df71/assets/docs-images/672d1aba471a903da827504b5c994c8437a38e4d9a2522e2ae6bf0dea4df286c-vislimit.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=AKIA6KXJSKKNFOCF7G4B%2F20260726%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20260726T044301Z&X-Amz-Expires=604800&X-Amz-Signature=cf238e5139c4aea437ae2db0bc247f8e33ffdeda42399445a51f639e94ad8a92&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject)

Different from a [Top N filter](/docs/top-n-filter) , limiting the display values lets you change which values are displayed without affecting the calculated totals and other values. You can also apply this limit using the [VisibilityLimit](/docs/visibilitylimit) function.

## Limit the display values

To limit which values are displayed in a grouped table, pivot table, or chart, do the following:

1. Select the down arrow (<img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/caret.svg" alt="" />), then select **Transform> Limit display values**.
2. For **Display**, choose whether to display the top or bottom number of values, and enter a number.

   For example, choose to display the bottom 10 values, and group the remaining values into an "Others" category.
3. For **by**, choose the function to use to order the aggregated column. Choose one of [**Rank**](/docs/rank), [**RankDense**](/docs/rankdense), or [**RowNumber**](/docs/rownumber).
4. For **Sort by**, select a column to sort the column by when choosing the top or bottom number of values. If the column is not aggregated, choose a function to aggregate by.
5. Click **Done**.

   If you chose to aggregate an unaggregated column, Sigma creates a grouping for your table with the column with limited display values as the group by column, and the aggregated column as the calculation in the grouping.

If you limit the display values in a pivot row or table columns, the Others category is added to the end of the list of columns.

### Remove a limit

After limiting display values, you can remove the limit:

1. For a column with display values limited, select the down arrow (<img src="https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/caret.svg" alt="" />) to open the column menu, then select **Transform> Limit display values**.
2. In the **Limit display values** modal, select **Remove limit**.

## Limitations

* You can only limit the display values of Text columns. Other data types, such as Number or Date, are not supported.
* If you change the sort order of the column used for to limit the display values, the values in the "Others" category change according to the sort because the Rank and RankDense functions rely on the sort order.