Formatting your analysis report

You can change the output from an analysis report by:

•	changing the way the report is marked up by changing the Markings shelf on the Encodings card (see Marking for more information).

•	exporting the final results to other programs (see Export to for more information).

•	changing the format of each part of the report (headers, cells and totals).

This section only deals with the last option.

To format output headers:

1.	Click Format > Headers format. The Default Headers Format dialog box displays.

2.	To change the Font:

a.	Deselect the Use defaults check box.

b.	Select the Font settings you want to use.

3.	To change the Fore color:

a.	Deselect the Use defaults check box.

b.	Click the Fore color block. The Color dialog box displays.

c.	Select the colour you want to use and click OK.

4.	To change the Back color:

a.	Deselect the Use defaults check box.

b.	Click the Back color block. The Color dialog box displays.

c.	Select the colour you want to use and click OK.

5.	Select the relevant radio button for the Text orientation you want to use.

6.	Click OK to confirm the changes and exit to your report.

You can return to the original defaults at any time by selecting the relevant Use defaults check box/es.

Default values may not be the same as the values displayed.

To format report data cells:

1.	Click Format > Data cells format. The Default Cells Format dialog box displays.

2.	To change the Font:

a.	Deselect the Use defaults check box.

b.	Select the Font settings you want to use.

3.	To change the Fore color:

a.	Deselect the Use defaults check box.

b.	Click the Fore color block. The Color dialog box displays.

c.	Select the colour you want to use and click OK.

4.	To change the Back color:

a.	Deselect the Use defaults check box.

b.	Click the Back color block. The Color dialog box displays.

c.	Select the colour you want to use and click OK.

5.	Click OK to confirm the changes and exit to your report.

You can return to the original defaults at any time by selecting the relevant Use defaults check box/es.

Default values may not be the same as the values displayed.

Working with totals

To format report totals:

1.	Click Format > Totals format. The Default Cells Format dialog box displays.

2.	To change the Font:

a.	Deselect the Use defaults check box.

b.	Select the Font settings you want to use.

3.	To change the Fore color:

a.	Deselect the Use defaults check box.

b.	Click the Fore color block. The Color dialog box displays.

c.	Select the colour you want to use and click OK.

4.	To change the Back color:

a.	Deselect the Use defaults check box.

b.	Click the Back color block. The Color dialog box displays.

c.	Select the colour you want to use and click OK.

5.	Click OK to confirm the changes and exit to your report.

Default values may not be the same as the values displayed.

Displaying and hiding totals

You can display totals by:

•	right-clicking a row or column and selecting Display totals; or

•	clicking the drop-down arrow of any field on either the Rows or Columns shelf and selecting Display totals.

If you select a row or the Rows shelf, the total of all the rows in the column will display. If you select a column or the Columns shelf, the total of all columns in the row will display.

You can hide totals by:

•	right-clicking a row or column and deselecting Display totals; or

•	clicking the drop-down arrow of any field on either the Rows or Columns shelf and deselecting Display totals.