Cross Table Properties – Formatting

Option

Description

Format by

Lists the alternatives by which it is possible to format the values in the cross table. The drop-down list contains the columns that are visible on the horizontal and vertical axes of the cross table. It also contains the alternative (Cell Values) which lets you format the values for each measure. Select the alternative you wish to format by to see the axis values available for that alternative. When you change from one alternative to another in the drop-down list, all the previous formatting settings in the cross table will be reset.

Axis values

Lists the values on the selected axis, as well as the current formatting category used for each value. Click on the alternative that you want to format. You can select more than one value if you want to apply the same formatting to them. Only the cell values in the selected columns or rows will be affected. If you select (Cell Values), the Axis values list will contain all columns and aggregation methods used on the cell values axis. If the cell values axis contains more than one column, formatting will always be applied to cell values and Format by will be grayed out, as seen below:

The cell values axis contains both Sum(Sales) and Sum(Cost), and the Format by drop-down list is grayed out.

Reset

Resets the formatting for the selected axis values according to the settings defined on column level. If no column formatting has been set, axis formatting settings defined in the Options dialog will be used. If no settings have been specified in the Options dialog, the default settings for the visualization type will be used.

Category

Lists the available formatting categories for the selected axis value. Each category in this list has separate settings. Which categories are available depends on the data type of the selected axis value. See Formatting Settings for a full description of all possible options.