Formatting the Cross-Tab

Change the background color of a dimension

1. Select the dimension.
2. Select the color from the Background Color drop down list.
3. Click Next if you have finished customizing your Cross-Tab.

Create an Alias for a Dimension

You can create aliases to shorten long dimension names. This is useful when you plan on referring to a dimensions in conditional formatting formulas (GridRowColumnValue function).

1. Select the dimension.
2. Enter the alias name.
3. Click Next if you have finished customizing your Cross-Tab.

Changing Grid Object Options

You can change the formatting of your grid objects using the check boxes associated with the following options:

• Show cell margins
• Indent row labels
• Repeat row labels
• Keep columns together
• Row totals on top
• Column totals on left
• Suppress empty rows
• Suppress empty columns.

Format grid lines

In the Format grid lines area you can define whether the lines show or not, as well as the color, style, and width.

1. Click Format Grid Lines.

   The Format Grid Lines dialog box appears.

2. From the list, choose the description of the area where you would like the lines to appear, or click the appropriate area in the Format Grid Line diagram.
3. Select the color, style, and width.
4. Select the Draw check box to have your lines appear in the report.
5. Click OK.
6. Click Next.

   The Chart tab appears.