Documentation

    Formatted table

    Formatted table presents source rows the way you want them read: choose columns, set number formats, add totals and color cells with rules. It doesn't change the source data.

    Format a regional orders table

    Six rows of orders show Revenue in euros with totals. Canada's two quarters are the only ones at 2,000 or more, so only they turn bold and green.

    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. In the Data tab, under Columns, drag a column to reorder it, or use × to remove it.
    2. Open the Design tab and scroll to Conditional formatting. The rule "Revenue at least 2000" is what highlights the larger values.
    3. Under Table style, choose Report to change the look of the whole table.

    When to use

    Use Formatted table for a table you hand to readers, such as a dashboard where large values should stand out. It keeps individual rows. To inspect raw data, use Table. To collapse rows into groups, use Pivot table.

    Inputs

    1 port
    Table

    Accepts: Tables.

    Accepts one connection on this port.

    Settings

    Columns

    Source fields to show as columns, and their formats.

    Choose columns explicitly

    Shows only the listed columns. Otherwise every source column shows, with any settings listed here. Each row is one source record.

    Default: false

    Maximum displayed source rows

    Most rows shown, after sorting.

    Default: 10000

    37 more settings
    Sorting

    How rows are sorted.

    Freeze first columns

    Number of columns, from the left, that stay in view while you scroll (0–100).

    Default: 0

    Show footer totals

    Shows or hides a totals row at the bottom. Choose each column's calculation in its settings.

    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

    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

    Show field types

    Shows or hides each column's data type.

    Default: false

    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

    Alternate fill

    Color of every other row.

    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

    Formatted table FAQs

    Does formatting change my data?
    No. Formats and rules change only what the table shows.
    Can it group rows?
    No. It shows rows as they arrive. To group rows or generate date periods, use Pivot table.

    Chart your data. Build it in Vista.

    Vista opens in your browser, with no account.