Spotfire® User Guide

CrossTable preferences

Preferences that an administrator can specify for the cross table.

Preference Description
BlankEmptyCellText Specifies whether to leave the cells with no data unfilled (True) or whether to use a text instead (False).
Default Title Specifies the default title of new cross tables. For example, it can be the current data table name: ${DataTable.DisplayName}
EmptyCellText Specifies the default text to show in empty cells. If this preference is left unchanged but the BlankEmptyCellText preference is set to False, the predefined default text in the text field will be a dash, -.
ExportCrossTableData Specifies whether a web client user is allowed to export the data from the cross table.
Font Lets you specify font settings for the text in the cross table cells.
HeaderFont Lets you specify font settings for the cross table headers.
LegendVisible Specifies whether the legend should be shown when creating a new cross table.
ShowColumnGrandTotals Specifies whether the sum of all values in a column should be shown.
ShowGridlines Specifies whether cell borders should be visible in the cross table.
ShowRowGrandTotals Specifies whether the sum of all values in a row should be shown.
SubtotalsLayout

Specifies whether to place the subtotals Before or After the cell values in the hierarchy of the vertical axis.

TotalsFont Lets you specify font settings for the cross table subtotals and grand total.
UseSeparateColorForMarkedItems Specifies whether the cross table should use a separate color for marked cells or just dim the unmarked cells.