Table Formatting
Style and layout options for table sections in paginated reports
Table sections are the workhorse of paginated reports. The options below control how a table looks, where its borders go, and how it splits across pages.
Table style comes from your theme
Every table and Matrix section in a report shares one look, set in your theme's Documents table style: row and column padding, text sizes, the header (size, weight, capitals or as written, background, text color), borders, striped rows and the totals row's look. Your theme can also print Document tables with the same style as your dashboards. See Themes and styles.
By default a report table has a filled header band, 12px text, 4px row padding and 8px column padding, and a line under the header and between rows. A single-line row is 29px tall.
Table sections keep Wrap text and the Totals row, alongside the page settings below.
Text Wrapping
When enabled, cell text wraps to multiple lines instead of being truncated. Wrapped cells preserve the full value but make rows taller.
Repeat Header on Page Break
When a table spans multiple pages, the column header row repeats at the top of each continuation page. Recommended for any table that runs longer than a single page.
Totals Row
Show a totals row at the bottom of the table. Each measure's total is one of two kinds, and you choose per measure in the Totals section of the table settings, on a dashboard card or a Document table section alike.
| Total | What it shows | Use when |
|---|---|---|
| Overall (the default) | The measure worked out once over everything the table covers: every row, on every page. | You want the true total: a distinct count of the distinct values, an average of all the underlying values. |
| Sum of rows | The table's rows added together. | "Add these up" is the question, for example a list of regional targets. |
Example
Orders by region, with a distinct count of customers. One customer ordered in both regions.
| Region | Unique customers |
|---|---|
| East | 2 |
| West | 2 |
| Total, Overall | 3 |
| Total, Sum of rows | 4 |
Overall counts the customer who bought in both regions once. Sum of rows counts them twice, and the settings say so under the choice: "Adds each row's value; a customer in two rows counts twice." For a plain sum, such as revenue, both kinds give the same number.
How each total reads
Hover the info icon on a total to see what it is: "Across the whole table" for Overall, "Sum of all rows" for Sum of rows.
- Measure filters. A table that keeps only some rows ("customers with more than 5 orders") totals only the rows it keeps.
- Pivoted tables. Each pivot column has its own total.
- Table calculations. A running total of a sum, with no partitions, totals to the measure over the whole table. A percent of the grand total totals to 100%. A moving average, a change from the previous value and a percent of each group's total have no single total, so the cell is empty and its info icon says why. You can still choose Sum of rows on any of them.
- Measures from separate tables. When a table combines measures from separate fact tables, a sum's total adds its rows, and a distinct count or average has no single overall value; the cell is empty and says so.
- Comparison tables. The current period and the comparison period each follow the measure's choice, and the change, percent change and ratio are worked out from the two totals, the same way each row's are. A comparison against a fixed target has no total for its target or change columns.
Every export of the table (CSV, Excel, PDF and scheduled reports) shows the same totals as the screen. Tables written in SQL keep their totals as before: the rows added together.
If a total changed
Totals used to add up every measure's rows, or stay empty for a distinct count or an average. Now a distinct count, an average or a median shows its Overall value, a comparison table totals its comparison columns, and a table whose rows can repeat a value (for example customers grouped by tag) totals each value once. To get the old number back for a measure, choose Sum of rows for it.
Column Formatting
Per-column number formatting carries over from the source table — number format, decimals, negative display, and conditional color. Edit formatting on the source table; the report reflects your changes on the next render.
Text wrapping and pagination
Semaphor splits table rows across pages by measuring each rendered row. Two things to know:
- Wrapping off — rows are uniform height, so more rows fit per page.
- Wrapping on — wrapped rows are taller, so fewer rows fit per page.
Either way, no content is dropped. The table simply uses more pages when rows are taller. If page count matters more than full text, turn wrapping off; if readability matters more, leave it on.