Crosstabs

Description

In a crosstab, data is displayed in columns and rows just as it is in tables. As opposed to tables, however, each column has at last one header, and each row has at least one row header. Corresponding data appears at the intersection of the column and row headers: this section is known as the "body."

The example crosstab displays revenue per service per quarter. The service labels are row headers, quarter labels are column headers. The revenue for each service for each quarter appears in the body.

To understand how items are laid out in a crosstab, picture the crosstab as a finished block. Objects placed in the lower-left quadrant of the crosstab provide the data for row headers, objects placed in the upper-right quadrant provide the data for column headers, and objects in the lower-right quadrant provide the data for the table body. You can't place any objects in the upper-left quadrant.

Suitable for

Presenting information in a multidimensional row/column format where one particular item is associated with another. For example, a type of service might be associated with a particular resort.

Keep in Mind

• Arrange the objects in the order you want them to appear in the block.
• Whether your document contains sections or not, you lay out the body of the table in the Block panel.
• Measure objects cannot be used in the vertical or horizontal headers; they can only be used in the body of the crosstab.
• You can use more than one object in the body of the crosstab.
• You can use more than one object in the vertical or horizontal headers.
  For example, you might use both the Service Line and Service objects in a header, so that both the service line and the type of service are displayed in the crosstab.
• The objects do not have to be part of the same class. You could, for instance, use the Service Line and Resort objects to display information per service line per resort.

Return to topic: Block Types

Return to topic: Working with Block Types