---
title: "Formatted table with totals in Vista | Oplema"
description: "Present source rows with chosen columns, number formats, totals and conditional formatting using the Formatted table visual in Vista."
url: "https://oplema.com/docs/vista/tables/formatted-table"
updated: "2026-11-04"
---

# 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.

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. 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.

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