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

# Format pivot table totals

In addition to customizing all cells in a table or pivot table by applying [table styles](/docs/format-and-customize-a-table#customize-the-table-style-for-an-individual-element), you can format pivot table totals separately from the other values in a pivot table:

* Apply unique formats to subtotals and grand totals in a pivot table, described in this document.
* Change the number format and appearance of totals rows and columns using the toolbar. See [Format column and totals data](/docs/format-and-customize-a-table#format-column-and-totals-data).
* Apply conditional formatting to subtotals and grand totals. See [Apply conditional formatting](/docs/format-and-customize-a-table#apply-conditional-formatting-to-table-columns-and-cells).

To show or hide subtotals and grand totals, see [Pivot table totals and subtotals](/docs/pivot-table-subtotals).

This document describes the format options for pivot table totals and explains how to customize the display of rows and columns containing subtotals and grant totals.

## User requirements

The ability to format pivot table totals requires the following:

* You must be assigned an [account type](/docs/account-type-and-license-overview) with the **Explore workbooks** or **Create, edit, and publish workbooks** permission enabled.

* You must be the workbook owner or be granted **Can explore** or **Can edit** [workbook permission](/docs/folder-and-document-permissions).

## Pivot table totals format options

### Subtotals

The **Subtotals** tools allow you to customize the font weight, font color, and background color of subtotal rows and columns.

![Pivot table showing store region and store state rows with quarter of date pivot columns and sum of quantity values. Subtotals for east and west regions are highlighted with a bright yellow background color and values are bold.](https://files.buildwithfern.com/sigma.docs.buildwithfern.com/3e4557773eba2388e5e1feef5065afa7e9ba69524fc726a5035038704a6e700e/assets/docs-images/cbeb00d48aa0e9854ad44f9f9c467893cb5ae180ab4b80c40508004fe8879472-pt-subtotals-form.png)

### Grand totals

The **Grand totals** tools allow you to customize the font weight, font color, and background color of the grand totals row and column.

![Pivot table showing store region and store state rows with quarter of date pivot columns and sum of quantity values. Grand total values are highlighted with a background color of pink and the font is bolded.](https://files.buildwithfern.com/sigma.docs.buildwithfern.com/1e5cc6b945596d185ef9ccd6cd22bf2c8e59326cba816152864e1873f446d642/assets/docs-images/3ae9970c0fbb75721d61e6dd3f69f56e32e1a6c225c95e0a1dedb2882b8e107e-pt-grand-form.png)

### Position

The **Position** setting allows you to move grand totals to the first or last column and row.

| First                                                                                                                                                                                      | Last                                                                                                                                                                               |
| :----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | :--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| ![Pivot table with totals showing at the top of the list in rows and columns](https://files.buildwithfern.com/sigma.docs.buildwithfern.com/33862b78111b66173983f65d95daed5d192232b66e248707b715152e2a84f5c8/assets/docs-images/fb7267830bafaead691c8477c234e850c9a906388eead4d446956dedd6d771de-pt-grand-first.png) | ![Pivot table with totals showing at the end of the rows and columns.](https://files.buildwithfern.com/sigma.docs.buildwithfern.com/1f0898aefb1df714a7de5bdd3087f28636dff61a501a76fa3c400f0023e4aade/assets/docs-images/0dd7e63463517a39a61b0093e5f81446bb7ec53f737bb094e8d5e823c473b9b8-pt-grand-last.png) |

## Format pivot table totals

1. Open a workbook for customizing or editing.
2. Select the pivot table you want to format.
3. In the side panel, select **Format**, then click the **Totals** header to expand the section.

   ![Pivot table showing store region and store state rows with quarter of date pivot columns and sum of quantity values. No formatting changes have been made.](https://files.buildwithfern.com/sigma.docs.buildwithfern.com/977543063dc0cdd89d4bb4e7825866f0008a4a449436bede8f6a2741e94153c3/assets/docs-images/cb63fc9e347b4a1a614b03453ed98803395adc86ff8efdb415657a29d995c714-pt-totals-unformatted.png)
4. Use the **Subtotals** and **Grand totals** options to customize font weight, font color, and background color. Select an option in the **Position** dropdown to control the position of the grand total row and column.

   ![Pivot table showing store region and store state rows with quarter of date pivot columns and sum of quantity values. Subtotals have a bright yellow background color and bold, and grand total values have a light pink background color and are bold.](https://files.buildwithfern.com/sigma.docs.buildwithfern.com/e511c2f904ea9c632050ce4a760ae99c445187d26b312743d38a6a02050ac2b3/assets/docs-images/9751f1f244d532399c4769060c0b2cf0f8491aa0e07de383d0c22562017e533b-pt-totals-formatted.png)