Crosstab Options

To specify additional attributes for a Crosstab, right-click on the Crosstab, and select 'Options' from the context menu. This opens the 'Crosstab Options' dialog box, with the following tabs: Option and Grid.

 

The available properties include the following:

To change the text in the summary headers, apply a text format to those cells. See For­mat Types for more information.

Show Summary Headers: Displays the column header names for the summary (aggregated measure) fields.

 

Summary Cells Side by Side: Displays summary headers just above the data cells (otherwise, on the left).

 

Show Row Grand Total: Displays the global aggregate computed across all row groups in the last row of the Crosstab.

 

Show Column Grand Total: Displays the global aggregate computed across all column groups in the last column of the Crosstab.

 

This option is not available when both row and column totals are suppressed.

Compute Totals for Displayed Groups Only: Computes the totals based only on the groups that are actually displayed in the table, i.e., groups selected by any Top- or Bottom-N filtering that you have specified. Disable this option to aggregate the totals based on all groups, including those groups that are not displayed in the table.

Row Total on Top: Places the row grand total (if displayed) in the first row following the columns headers, rather than in the last row.

 

Column Total on Left: Places the column grand total (if displayed) in the first column following the row headers, rather than in the last column.

 

Fill Blank Cell with Zero: Place zeros in aggregate cells for which there are no corresponding records. Otherwise, the cells are left blank (default).

 

Keep Original Column Headers: Places the field names for the Crosstab row headers at the top of the corresponding column.

 

Grand Total Label: Sets the header text for the row grand total and column grand total, when displayed.

 

Percentage: Specifies the basis on which percentages are computed when you select the 'Percent' option from a measure in the Binding panel. (See Modifying Summary Properties for information on editing a measure representation.) The 'By columns' option computes the percentage so that the sum of the measure across columns in a single row is 100%, either within each group or across all groups (depending on the specified 'Percent' option in the Binding panel). The 'By rows' option computes the percentage so that the sum of the measure across rows in a single column is 100%, either within each group or across all groups (depending on the specified 'Percent' option in the Binding panel).

The Borders tab allows you to change the visual appearance of the Crosstab. Click a border in the 'Crosstab Grid' area to define crosstab border formatting.

 

<< 6.5.2 Creating a Crosstab Using Freehand Operations © 1996-2013 InetSoft Technology Corporation (v11.5) 6.6 Binding Data to a Chart Element >>