4.3.1 Creating a Crosstab
To add a crosstab to a Viewsheet, follow the steps below:
1. Drag the Crosstab element from the component tree into the Viewsheet grid.
2. Move the mouse over the top right corner of the crosstab, and click the 'Edit' button.

This opens the crosstab data dialog box.

The panel displays all OLAP cubes defined on the data source.
3. In the Data Source panel, expand a Data Block, query, data model, or OLAP cube (hierarchical model) to display the available dimensions and measures.
4. Drag the desired columns or cube dimensions into the 'Column Headers' and 'Row Headers' regions.

You can change the order of multiple headers or measures by dragging them up or down.
5. Drag the desired columns or cube measures into the region labeled 'Measures'.

6. (Optional) Specify group totals and ranking:
a. Click on a row header or column header. This activates the 'Sort', 'Ranking', and 'Group Total' controls.
b. In the 'Sort' menu, specify how the values in the field should be ordered. 'Ascending' and 'Descending' sort the values in alphabetical or reverse-alphabetical order. 'By Value (Asc)' and 'By Value (Desc)' sort the values according to the aggregate measure selected in the adjacent menu.
To specify an arbitrary sort order, select the 'Manual' option in the 'Sort' menu, and press the 'Edit' button to open the 'Manual Ordering' dialog box. To reorder an item in the 'Manual Ordering' dialog box, drag the item up or down within the list or select the item and press the 'Up' or 'Down' buttons. Press 'OK' to close the dialog box.

c. In the 'Group Total' menu, specify whether group totals should be shown.
d. In the 'Ranking' menu, Select the 'Top' or 'Bottom' filter, and specify the (integer) number of top or bottom groups to select. In the adjacent menu, specify the measure by which groups should be ranked.
e. Select 'Group all others together' to create an “Others” category which represents (in aggregate) all the groups excluded by the Top/Bottom-N filter.
These controls are disabled for OLAP cubes. Cube aggregations are defined in the model itself. (See OLAP Overlay – Multidimensional Analysis in the Data Modeling.)
7. Click on a measure, and select the summarization method from the 'Aggregate' menu.

a. To display a univariate measure ('Sum', 'Count', etc.) as a percentage, select the basis for percentage in the 'Percentage of' menu.

b. If you choose a percentage representation, click the 'Options' button (at the top of the dialog box) to select the dimension along which the percentage is computed ('Rows' or 'Columns'). Percentage by rows uses the row totals, and by columns uses the column totals.

c. To display a bivariate aggregation measure (e.g., 'Correlation', 'Weighted Average', etc.), select the second operand (column) from the 'with' menu.
8. Click on the 'Apply' button (the arrow on the top right) to close the binding dialog box.
9. If desired, expand the crosstab horizontally so that all of the column headers are visible.
See Also
Percentage Representation for Aggregation, to display data as a percentage.
Crosstab Aggregation Methods for information on summarization options.
OLAP Overlay – Multidimensional Analysis, in Data Modeling, for general information on hierarchical overlays.
| << 4.3 Crosstabs | © 1996-2013 InetSoft Technology Corporation (v11.4) | 4.3.2 Crosstab Properties >> |