Set Crosstab Properties

Format crosstabs to give them the appearance you want. You can specify formatting for rows, columns, and fact cells in a crosstab or for the entire crosstab. When you specify formatting for all rows, columns, fact cells, or the crosstab, the formatting is automatically applied to any new items you add.

If you apply the same styles, such as font color, to crosstab rows, columns, and crosstab intersections, the styles are applied in the following order:

  1. crosstab fact cells
  2. fact cells in the outermost rows
  3. fact cells in the innermost rows
  4. fact cells in the outermost columns
  5. fact cells in the innermost columns
  6. crosstab intersections

The style applied to the last object in the list overrides styles applied to previous objects. In addition, class styles are applied before styles that you apply manually.

You can also quickly format crosstabs by applying table styles and add white space to a crosstab by inserting crosstab space objects.

Tip: In cases where fact cell formatting applied to rows conflicts with fact cell formatting applied to columns, you can set the Fact Cells Precedence property in the Properties pane to determine whether the row formatting or the column formatting has precedence. To set this property, click anywhere in the crosstab, click the Select ancestor icon in the title bar of the Properties pane, and click Crosstab. Or you can click the container selector (three orange dots) of the crosstab to select it.

Procedure

  1. To format the entire crosstab, do the following:
    1. Click anywhere in the crosstab.
    2. Click the Select ancestor icon select ancestor icon in the title bar of the Properties pane and click Crosstab.
    3. In the Properties pane, set the property value.
      For example, to specify a background color, click Background Color and choose a color.
  2. To format all rows, columns, or fact cells, click a row, column, or fact cell in the crosstab and then do the following:
    1. If you clicked a row, click the Select ancestor icon in the title bar of the Properties pane and click Crosstab Rows.
    2. If you clicked a column, click the Select ancestor icon in the title bar of the Properties pane and click Crosstab Columns.
    3. If you clicked a fact cell, click the select ancestor button in the title bar of the Properties pane and click Crosstab Fact Cells.
    4. In the Properties pane, set the property value.
      For example, to specify a background color, click Background Color and choose the color.
      Tip: You can also right-click the row or column and click Select Fact Cells.
  3. To format all crosstab cells for a specific row or column, do the following:
    1. Click the row or column.
    2. Click the Select ancestor icon in the title bar of the Properties pane and click Crosstab Member Fact Cells.
      Tip: You can also right-click the row or column and click Select Member Fact Cells.
    3. In the Properties pane, set the property value.
      For example, to specify a background color, click Background Color and choose the color.
  4. To format all row or column titles, do the following:
    1. Click a row or column title.
    2. Click the Select ancestor icon in the title bar of the Properties pane and click Crosstab Rows or Crosstab Columns.
    3. In the Properties pane, set the property value.
      For example, to specify a background color, click Background Color and choose the color.
  5. To format an individual row, column, or intersection, do the following:
    1. Click the row, column, or intersection.
      Tip: To format the data in a row, column, or intersection, click the More icon More icon, click the Locked icon unlock icon, and then click the text item to format.
    2. In the Properties pane, set the property value.
      For example, to specify a background color, click Background Color and choose the color.