Working with Crosstabs
A crosstab is a statistical component that summarizes categorical data in one or more row and column groups in a concise format for analysis or reporting, optionally with hierarchical structure. It usually represents the joint distribution of two or more variables in compact row and column format. A common term for a crosstab is a pivot table. In business intelligence, engineering, survey, and scientific research, the crosstab is widely used. This topic introduces how you can insert and modify crosstabs in reports and use crosstab formulas to get the data your want.
Logi Report also provides a unique compound crosstab that enables you to put multiple crosstabs together in a very flexible structure. This makes far more sophisticated crosstab analysis possible. However, Logi Report only support compound crosstabs in page reports that use query resources.
The following topics discuss crosstabs in further detail:
See an example: The SampleComponents catalog, included with Designer, contains reports that have examples of how you could use each component type in a report. For the crosstab component example, open <install_root>\Demo\Reports\SampleComponents\Crosstab.cls
.