Expanding CrossTab reports
Expanding CrossTab reports lets you open a CrossTab report onto several different spreadsheets of a notebook. You can expand a report only if you have a field in the Pages position of the CrossTab report. For example, suppose you generate a CrossTab report, which is placed on spreadsheet B that has a field named “Year” in the Pages position with two field items, 1990 and 1991. When you expand the CrossTab report, the first field item (1990) and the data associated with it are placed on spreadsheet C, and the second field item (1991) and the data associated with it are placed on spreadsheet D.
To expand a CrossTab report |  |
|
1.
|
|
Click a cell on a CrossTab report.
|
|
2.
|
|
Click Tools
 Data tools CrossTab Expand. |
|
•
|
|
The report is expanded to the next available, unprotected spreadsheet of the notebook.
|