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.
Pivot table interactive example
Loading interactive example…
The live example needs a desktop screen. The result it produces is shown here, and the explanation and settings below work on any screen.
| 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 |
- Select the arrow next to Europe in the table to collapse its countries.
- In the Data tab, under Rows, use × to remove
Country. The table now has one row per region. - 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
- 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:
MondayOptions: Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday.
- Fiscal year starts
Month the fiscal year starts in. Sets quarter and year boundaries.
Default:
JanuaryOptions: 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.