WordPerfect Office X3 User Guide
CrossTab report feature analyzes data by using selected data fields as
row or column labels and numeric data fields as the data being
analyzed. The fields in the row and column areas are used as selection
criteria to determine which values from the database to include at
intersections of the row and column field labels. For example, assume
a database contains product sales information (data). In the CrossTab
report, place the field containing the names of the company's
salespeople along the left of the spreadsheet (rows), and the field
containing the products you sell along the top of the spreadsheet
(columns). The intersection of the labels “Salesperson A” and “Products”
shows the total number of products that Salesperson A sold.
To build a CrossTab report
1 Click a spreadsheet cell containing data.
2 Click Tools ` Data tools ` CrossTab ` Report.
3 Drag any fields from the list in the Fields area into any of the
following positions of the Layout area:
4 Type the report destination in the Destination box.
Unless you select a destination, the CrossTab report will be placed
in A1 of the next available, unprotected spreadsheet.
Dragging a field to the Pages position is optional. Fields placed
in the Pages position appear in the upper-left corner of the
CrossTab report as items in a list box so that you can select the
desired field item to view. If fields are placed in the Pages
position, you can expand the report. For more information about
expanding CrossTab reports, see “Expanding CrossTab reports”
in the online Help.