Configuring Formatting in Tables

The Formatting Configuration Format brush. controls the formatting of your report or statement.

Formatting Configuration

You can format the presentation of your report after you have created it by clicking Format brush.. The following options are available in the formatting configuration modal.

  • Column Density. Available options are: Compact, which has less space between table elements, and Comfy, which has more space between table elements.
  • Table Height. Available options are: Small, Medium, and Fit Content.
  • Resizing Table Height. Drag your table to reduce or increase its height.
  • Freeze Columns. Available options are: Yes or No. Allows you to freeze report columns while scrolling through others. This functionality is only available for columns derived from groupings in Analytics lenses.
  • Show Grid. Adds borders to rows in your report. Available options are None [default], All, Total and Subtotal Rows.
  • Header Currency Format. Available options are: ISO Code, Symbol, or None. Selects the format in which currency is displayed in your columns.
  • Ignore Warnings. Available options are: Yes or No. This selection allows you to ignore any warning messages presented on the display table. The ignored messages are not shown in the table view and this selection persists after you close a report and reopen it.
  • Reverse Sign. Displays all negative numbers as positive numbers in your report, and vice versa. To reverse the signs on an individual lens, use the Reverse Sign option available in the Lens Configuration tab.
  • Negative Number Color. You can choose to display negative values in black or red, and whether to prefix these values with a minus, or enclose them in parentheses.
  • Negative Number Format. Available options are: Minus or Brackets. Depending on the selected value negative numbers are displayed either preceded by a "-" sign or in between brackets.
  • Empty Values Format. Available options are: Zero, Blank, or Dash. Selects the format in which empty values are displayed by the table.
  • Divide by Zero Format. Available options are: Error Message, Zero, Blank, or Dash. Selects the format in which divisions by zero are displayed by the table. When selecting "Error Message" the default "#DIV/0!" error is displayed.
  • Suppress Row Calculations. You can use the toggle to activate or deactivate this feature. This selection allows you to suppress row calculations where they are not necessary. For example, if you have a column that contains unit prices and you do not need a total and subtotal, this selection allows you to suppress row calculations for this column.
  • Sorting Columns. You can sort your table by single columns when you have only one lens. Available options are: least recent to most recent for date columns, alphabetical order for dimension columns, and smallest to largest for measure columns. You can change the sorting direction of your column by clicking the column header. If you have any active subtotals or you have enabled real-time, you cannot sort your columns.
Tip: After selecting any changes you want to apply to the report, ensure you click Save in the Table Configuration. This automatically closes the configuration page and reloads your table. To confirm your changes are applied, a prompt is displayed indicating your table configuration has been saved successfully.