Table Options

Table options

Use Table options to configure the layout, calculated values, and display of a table report. Changes are shown in a live preview while the dialog is open. Select Apply to use the draft for the current report, then use the report save action to persist it.

Live preview

The preview uses the current report data and filters. It displays at most seven rows so that the controls and result remain visible together. It is only a preview: it does not change the report table until you select Apply.

Select a column heading in the preview to open its settings in the Columns section. When totals are enabled, they are calculated from all loaded report rows, not only the rows shown in the preview.

Layout

Choose one of the two layouts and arrange fields by drag and drop. The arrow buttons next to a field provide an alternative way to change its order.

Table

Use Table for a normal list. Fields in Visible columns are displayed from top to bottom in that order. Move a field to Hidden columns to omit it. A table must have at least one visible column.

Pivot table

Use Pivot table to turn one field into rows, one into columns, and one into values. The current implementation requires exactly one field in each of Rows, Columns, and Values.

Each combination of the selected row and column field must identify one report row. If more than one report row would occupy the same pivot cell, aggregate or filter the report before using the pivot layout.

Columns

Choose a column from the list, or select its heading in the live preview, to configure it. The following settings apply only to that column:

• Display name changes the heading without changing the source data.
• Format can be Automatic, Text, Number, Currency, or Percent. Text keeps numeric-looking values as text. Percent formats fractional values such as 0.25 as 25%; calculated percentage columns retain their expected percentage scale.
• Currency accepts a three-letter currency code such as EUR when Currency format is selected.
• Decimal places fixes the displayed precision from 0 to 6 decimals; Automatic lets Analytics choose it.
• Alignment sets the column to left, centre, or right alignment.
• Width sets a width from 40 to 1000 pixels.
• Wrap text lets long cell values wrap to additional lines.

Reset column removes the custom settings for the selected column, including its display formatting and highlight limit.

Calculated Columns

Use Add calculated column to derive a new value from columns in the selected layout. Give the calculated column a title, choose a calculation method, then choose its source columns. Their order matters for subtraction, division, and percentage calculations.

• Add adds all selected source columns.
• Subtract uses the first source as the base value and subtracts every following source.
• Multiply multiplies the selected source columns.
• Divide divides the first source by every following source.
• Percentage uses the first source as the numerator and the second as the denominator.
• Own formula supports displayed column references in square brackets, fixed numbers, +, -, *, /, parentheses, and ROUND(value) or ROUND(value, decimals). For example: (30 * [Quantity]) + ([Price] * -1).

Edit a calculated-column card to change it, or remove it from the editor. A source column that is no longer available in the selected layout must be restored before the calculation can be saved.

Appearance

Use this section to control the rendered table:

• Row spacing chooses Comfortable or Compact row density.
• Show column headers shows or hides the table header row.
• Alternating row shading makes neighbouring rows easier to follow.
• Rows per page chooses 10, 25, 50, or 100 rows for the report table. The live preview remains limited to seven rows.
• Show totals adds a footer. Regular numeric columns are summed; a calculated percentage total is calculated from the summed numerator and denominator.
• Format all numbers in local format uses the viewer's locale for decimal and thousands separators.

Highlighting

Choose a column and enter a value in Values below to mark numeric values strictly below that limit with a background and downward marker. Leave the value empty to disable the table-option highlight. Existing report thresholds continue to apply as well.

Reset or discard changes

Reset to defaults restores the dialog's draft to the default table layout and display settings. Cancel discards the draft. Neither action changes the report table until Apply is selected.