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

# Dataset Totals (Deprecated)

> Create dataset worksheet totals as single-value column aggregates in the Sigma column view tab of the right panel. Totals are single value column aggregates that live at the top most level or a worksheet. Totals can be created in a dataset worksheet's right hand panel, under the column view tab.

[Datasets](/docs/datasets) are deprecated:

* Starting June 2, 2026, you will no longer be able to create datasets or edit existing datasets.
* Starting September 15, 2026, you will no longer be able to use datasets as a data source or view datasets in Sigma.

Migrate your datasets to data models and update any documents that use datasets as a data source to use a different source. See [Migrate a dataset to a data model](/docs/migrate-a-dataset-to-a-data-model).

## Create a Total

1. Open the **column view tab** in your worksheet’s right hand panel.

   ![](https://fdr-prod-docs-files-public.s3.us-east-1.amazonaws.com/sigma.docs.buildwithfern.com/091202e8545b3e5c42fead2bf746ef9dffe4639592b0eacbf44f591f9e80e11e/assets/docs-images/49e2dbc-45-totals-right-inspector.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=AKIA6KXJSKKNFOCF7G4B%2F20260725%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20260725T074216Z&X-Amz-Expires=604800&X-Amz-Signature=94ead654342bdba79f7abd9f09eeac4a54d6ed59990a5fefec5331bce079be92&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject)
2. Under the **TOTALS** section, click on **New Total...**
3. Select a column from the list to automatically create a recommended aggregate total. Or select
   **Add Empty Column** to write your own formula.

   For this example, select the column *Sales Amount*. A new column is automatically created, *Sales Amount - Sum*, which calculates the formula `Sum([Sales Amount])`.

   The column appears in the right hand **TOTALS** list, its formula is accessible in the formula bar, and the calculated value is displayed under the TOTALS list in the control panel.

![](https://fdr-prod-docs-files-public.s3.us-east-1.amazonaws.com/sigma.docs.buildwithfern.com/0e9fff6071d38425f5ba7a342248dff1c524c0d562bbebaad999fbdcea14cfdf/assets/docs-images/966e943-46_-_new_total.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=AKIA6KXJSKKNFOCF7G4B%2F20260725%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20260725T074216Z&X-Amz-Expires=604800&X-Amz-Signature=dc7f0c6e890ee8774b22bbf842e2d66e6077db01d2d6711a22516103f7038f37&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject)