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

# Views

> A saved pivot or perspective over a table — grouping, aggregations, filters, and sorting, read live.

A **view** is a saved **pivot or perspective** over a single [table](/features/tables) — a stored arrangement of grouping, aggregations, filters, sorting, and calculated fields. It reads **live** from the table (nothing is materialized), and it's a first-class object: views appear on the [Tables](/features/tables) page with **Type = View**, and [dashboard cards](/features/artifacts/dashboards#data-sources) are built on the same view shape.

**Where each action lives in the UI** (for telling users where to click):

* A view always belongs to a **parent table**. Open a table (`/table/{tableId}`), then use the **Views** dropdown in the grid toolbar to switch between **Default** (the raw table) and its saved views; a view opens at `/table/{tableId}/views/{viewId}`.
* **Create/edit**: change the pivot (grouping, values, filters, sort) on Default or a view; that starts a **draft**. Save it with **Save** (update this view), **Save as New** (make a new view), or **Reset** (discard the draft).
* **Delete**: the trash affordance on a view's row in the Views dropdown.
* A view is a read-only live slice; for a new persisted or joinable dataset use a [calculation table](/features/tables/calculation) instead.

<Warning>
  Calculated fields inside a view are gated by the `calculated_fields` feature flag. The `summation_views` flag does **not** gate whether views appear — views work with it off (it defaults to false); it only toggles the ViewCard header's copy / download / open actions and the calculated-field entry point, not the Views dropdown, pivot panel, Save, or the view route.
</Warning>

## What you can do

Build a view from the **Pivoting** panel — the pivot icon in the table toolbar. Its sections are **Row**, **Column**, **Values**, and **Filter**:

* **Row** — group by one or more columns down the left. Ordering lives inside each Row field (its **Order:** and **Sort by:** controls), as do its **Show total** and **Show grand total** checkboxes.
* **Column** — pivot columns across the top, with the same per-field total checkboxes.
* **Values** — the measures to aggregate (sum, count, average, min, max, median, distinct count), plus calculated expressions.
* **Filter** — restrict which rows the view includes.

Below these, an untitled card holds just **Tree view** and **Repeat row label**.

<Frame caption="A pivoted view and its Pivoting panel">
  <img src="https://mintcdn.com/summation-676748f5/ewrpxeNnW54PEh54/images/features/tables/views/view-pivoting.png?fit=max&auto=format&n=ewrpxeNnW54PEh54&q=85&s=55a8e2dcc733df6b46883927e788dfe9" alt="A pivoted view 'PivotedViewDemo': rows grouped by country and athlete, columns pivoted by sport (Archery, Athletics) each with sum_gold, sum_silver, sum_bronze, and sum values, and per-country total rows. The Pivoting panel on the right has Tree view and Repeat row label toggles, and Row (country, athlete), Column (year, sport), Values (sum_gold, sum_silver, sum_bronze, sum), and Filter sections. Save as New, Save, and Import are top-right." width="2954" height="1968" data-path="images/features/tables/views/view-pivoting.png" />
</Frame>

A view is a lightweight, live slice of one table. When you need a new persisted or joinable dataset, create a [calculation table](/features/tables/calculation) instead.

## Formatting

Style a view from the **Formatting** panel (the paintbrush icon in the toolbar). The button is enabled only when a **view** is open, so the raw **Default** table can't be formatted. By default the panel targets the whole **Table** (the **Selected Cells** option is disabled); with the `conditional_formatting` flag on, the target segments become **All**, **Headers**, and **Cells**. Either way the controls are **cell color**, **text** style (bold, underline, italic, strikethrough), **alignment**, **wrapping**, **borders**, a **prefix / suffix**, a **multiplier**, and **number display**.

<Frame caption="The Formatting panel (Selected Cells)">
  <img src="https://mintcdn.com/summation-676748f5/ewrpxeNnW54PEh54/images/features/tables/views/formatting.png?fit=max&auto=format&n=ewrpxeNnW54PEh54&q=85&s=a1c3205a4b5081f8cd18faff89444a77" alt="A formatted pivot view 'A Pivot Formatted' with the sum_gold column highlighted blue. The Formatting panel on the right has a Table / Selected Cells toggle and controls for Cell Color, Text (bold, underline, italic, strikethrough), Alignment, Wrapping, Borders, Base (Prefix / Suffix), Multiplier, and Number display, plus a 'Clear Selected Formatting' action." width="2958" height="1964" data-path="images/features/tables/views/formatting.png" />
</Frame>

## Create and manage

<Tabs sync={false}>
  <Tab title="In the app">
    Open a table and use the **Views** dropdown in the grid toolbar. **Default** is the raw table; selecting a saved view opens it. Editing the pivot (in the **Pivoting** panel) starts a **draft** (marked "Unsaved changes"), then:

    * **Save** — update the current view.
    * **Save as New** — promote the draft to a brand-new view.
    * **Reset** — discard the draft and return to the parent.

    Delete a view from the trash icon on its row in the Views dropdown.

    <Frame caption="The table toolbar: the Views dropdown and the Pivoting button">
      <img src="https://mintcdn.com/summation-676748f5/ewrpxeNnW54PEh54/images/features/tables/views/pivoting-toolbar.png?fit=max&auto=format&n=ewrpxeNnW54PEh54&q=85&s=077b354963963a89c00d42b4c5968f5a" alt="The grid toolbar for the table 'olympics_event' showing a 'Views' dropdown and, to its right, the highlighted Pivoting button (a pivot icon with a 'Pivoting' tooltip)." width="936" height="168" data-path="images/features/tables/views/pivoting-toolbar.png" />
    </Frame>
  </Tab>

  <Tab title="Via the API">
    <Card title="GET /v1/views" icon="code" href="/api-reference/views/list-views" horizontal>
      List views (optionally for one table).
    </Card>

    <Card title="GET /v1/views/{viewId}" icon="code" href="/api-reference/views/show-view" horizontal>
      Show a view's definition.
    </Card>

    <Card title="GET /v1/views/{viewId}/data" icon="code" href="/api-reference/views/fetch-view-data" horizontal>
      Fetch a page of the view's rows.
    </Card>

    <Card title="DELETE /v1/views/{viewId}" icon="code" href="/api-reference/views/delete-view" horizontal>
      Delete a view.
    </Card>

    <Card title="Coming soon" icon="clock" horizontal>
      Create a view.
    </Card>
  </Tab>
</Tabs>

## Catalog

Like tables, every view carries a **catalog** (a description, owner, agent-facing description, and per-column descriptions) that Addison reads. See [Catalog](/features/tables#catalog) for what it holds and where to edit it.

<Tabs sync={false}>
  <Tab title="In the app">
    Open the **Catalog** panel from the book icon in the view's toolbar, the same as for a table.
  </Tab>

  <Tab title="Via the API">
    <Card title="GET /v1/views/{viewId}/catalog" icon="code" href="/api-reference/views/show-view-catalog" horizontal>
      Show a view's catalog.
    </Card>

    <Card title="PATCH /v1/views/{viewId}/catalog" icon="code" href="/api-reference/views/update-view-catalog" horizontal>
      Update a view's catalog (description, owner, agent description).
    </Card>
  </Tab>
</Tabs>
