> ## Documentation Index
> Fetch the complete documentation index at: https://docs.oncarbon.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Pivots

> Cross-tabulate your analytics into nested, subtotalled tables.

Pivots are saved, interactive tables that group your analytics by one or more dimensions and summarise them with measures. Create and manage them from **Pivots** in the dashboard.

## Create a pivot

Select **New pivot**, then enter a name and an optional description. Carbon creates the pivot and opens it so you can shape it.

## Shape a pivot

The configuration panel sits beside a live preview.

| Field         | Configure                                                                              |
| ------------- | -------------------------------------------------------------------------------------- |
| **Rows**      | One to three dimensions, nested in the order you select them                           |
| **Column**    | An optional dimension whose values become columns (a crosstab)                         |
| **Measures**  | One to four measures, shown as value columns                                           |
| **Sort by**   | Order rows by a measure or dimension, ascending or descending                          |
| **Subtotals** | Row subtotals, a grand total, and — with a column dimension — a rolled-up Total column |

Every change re-runs against the selected time range and page-level filters. Select **Save** to persist the configuration.

## Subtotals

When subtotals are on, each row group shows its subtotal and the table ends with a grand total. These values are re-aggregated by the query engine at each rollup level — never summed in the browser — so ratios and percentiles stay correct (a p95 subtotal is the p95 over the group, not an average of its rows).

With a column dimension, subtotals also add a **Total** column that rolls each row up across the pivoted values.

## Arrange

Row groups are collapsible — select a group's chevron to fold or unfold its children.

<Note>Each pivot groups by up to three row dimensions and four measures. Each space can have up to 20 pivots.</Note>