---
title: "Pivot table in Vista | Oplema"
description: "Group source rows into rows, columns and values and add subtotals and totals with the Pivot table visual, to summarize data on a Vista dashboard."
url: "https://oplema.com/docs/vista/tables/pivot-table"
updated: "2026-11-04"
---

# Pivot table

Pivot table groups source rows into a summary. Choose Rows, Columns and Values, then add subtotals and totals. Totals are calculated from the contributing source rows.

## Summarize revenue by region and quarter

Revenue is grouped by region and country in the rows and by quarter in the columns. Each region gets its own subtotal, so Denmark and Sweden add up under Europe.

Result
| Region | Country | Year | Quarter | Revenue | Orders |
| --- | --- | --- | --- | --- | --- |
| Europe | Denmark | 2026 | Q1 | 1200 | 12 |
| Europe | Denmark | 2026 | Q2 | 1800 | 16 |
| Europe | Sweden | 2026 | Q1 | 900 | 9 |
| Europe | Sweden | 2026 | Q2 | 1500 | 13 |
| Americas | Canada | 2026 | Q1 | 2100 | 18 |
| Americas | Canada | 2026 | Q2 | 2400 | 21 |

1. Select the arrow next to Europe in the table to collapse its countries.
2. In the Data tab, under Rows, use × to remove `Country`. The table now has one row per region.
3. Under Values, use Add to add another calculated measure, then open the Design tab to change Table style.

## When to use

Use Pivot table to replace individual rows with a summary across two or more categories, such as revenue by region and quarter. Totals come from the contributing source rows. To keep each row visible, use Formatted table.

## Inputs

1 port

**Table**

Accepts: Tables.

Accepts one connection on this port.

## Settings

**Rows**

Fields that form the row groups.

**Columns**

Fields that form the column groups.

**Values**

Values to calculate. Each cell summarizes the source rows where its row group and column group meet. Totals are calculated again from those rows.

36 more settings

**Sort row groups by**

Sorts row groups by a value.

**Total at bottom**

Shows or hides the grand total row.

Default: `true`

**Total at right**

Shows or hides the grand total column.

Default: `true`

**Show missing combinations as zero**

Shows zero where a row group and column group have no rows.

Default: `false`

**Source timezone**

IANA time zone for timestamps without an offset, such as Europe/Copenhagen. Ambiguous local times need an explicit offset.

Default: `UTC`

**Chart timezone**

IANA time zone used for grouping and display. Vista filters keep their own time zone.

Default: `UTC`

**Week starts**

Day the week starts on.

Default: `Monday`

Options: Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday.

**Fiscal year starts**

Month the fiscal year starts in. Sets quarter and year boundaries.

Default: `January`

Options: January, February, March, April, May, June, July, August, September, October, November, December.

**Show tooltip**

Shows or hides values when you hover over a mark.

Default: `true`

**Tooltip**

Text shown when you hover over a mark. Write it in the editor and insert values from Values.

**Values (Tooltips)**

Values you can insert into the text. Each row calculates a value from a source field or, in charts, shows a chart value, and can have its own number or date format.

**Show headers**

Shows or hides the header row.

Default: `true`

**Text size (Headers)**

Size of the header text.

Default: `12`

**Bold**

Shows headers in bold.

Default: `true`

**Text colour (Headers)**

Text color of the header row.

**Fill colour (Headers)**

Fill color of the header row.

**Sticky headers**

Keeps the header row in view while scrolling.

Default: `true`

**Padding**

Space inside the header cells.

Default: `8`

**Text size (Body)**

Size of the body text.

Default: `12`

**Text colour (Body)**

Color of the body text.

**Fill colour (Body)**

Background color.

**Alternate row colours**

Shades every other row.

Default: `false`

**Row padding**

Space above and below the text in each body row, in pixels.

Default: `6`

**Missing values**

Text shown for missing values.

**Horizontal lines**

Shows or hides lines between rows.

Default: `true`

**Vertical lines**

Shows or hides lines between columns.

Default: `false`

**Colour**

Color of the table lines and borders.

**Thickness**

Thickness of the table lines.

Default: `1`

**Totals label**

Text that labels the totals.

Default: `Total`

**Totals text color**

Text color of the totals.

**Totals background**

Fill color of the totals.

**Bold totals**

Shows totals in bold.

Default: `true`

**Separate totals with border**

Draws a line above the totals.

Default: `true`

**Conditional formatting**

Rules that change how cells look based on their values.

**Corner radius (px)**

Corner radius in whole logical pixels.

Default: `0`

**Border width (px)**

Border width in whole logical pixels.

Default: `0`

## Pivot table FAQs

**How are pivot totals calculated?**

From the source rows that contribute to them, not by adding up displayed values.

**Can it show missing dates?**

Yes. Date dimensions can generate missing periods between the first and last observation. See Missing values in the Data tab.

### Chart your data. Build it in Vista.

Vista opens in your browser, with no account.

[Open Vista](https://oplema.com/editor?path=%2F%3Fopen%3Dvista) [About Vista](https://oplema.com/vista)
