Documentation

    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.

    The live example needs a desktop screen. The result it produces is shown here, and the explanation and settings below work on any screen.

    Result
    RegionCountryYearQuarterRevenueOrders
    EuropeDenmark2026Q1120012
    EuropeDenmark2026Q2180016
    EuropeSweden2026Q19009
    EuropeSweden2026Q2150013
    AmericasCanada2026Q1210018
    AmericasCanada2026Q2240021
    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.