Formatting CrossTab reports
Once you summarize data in a CrossTab report, you can align data fields by row or column. You can also display the totals and grand totals for both column and row data. Showing column and row totals is useful because it gives you a better understanding of how each field relates to the total and can help you see an overall picture of the data.
You can also change the appearance of a CrossTab report by changing formatting options, such as the numeric format, and the alignment of labels.
To align data fields in a CrossTab report |  |
|
1.
|
|
Click a cell in a CrossTab report.
|
|
2.
|
|
Click Tools
 Data tools CrossTab Report. |
|
3.
|
|
Enable one of the following options:
|
|
•
|
By row — data appears vertically in the report
|
|
•
|
By columns — data appears horizontally in the report
|
|
•
|
|
By default, data fields are aligned by row.
|
To show column summaries in a CrossTab report | |
|
1.
|
|
Click a cell in a CrossTab report.
|
|
2.
|
|
Click Tools
Data tools CrossTab Options. |
|
3.
|
|
Enable the Show column summaries check box.
|
|
•
|
|
You can also show row summaries by enabling the Show row summaries check box.
|
To customize the appearance of a CrossTab report | |
|
1.
|
|
Click Tools
Data tools CrossTab Options. |
|
2.
|
|
Enable any of the following check boxes:
|
|
•
|
Format CrossTab report — applies a preset format to the fields and data, making the report easier to read
|
|
•
|
Preserve data formatting — maintains the numeric format of the source data, such as currency
|
|
•
|
Center labels across blocks of cells — centers the field names (labels) across the column of data. (By default, field names are left-aligned).
|