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