This topic describes how to use the Report Designer to create a Crosstab report. A Crosstab report shows the relationships between three or more items, and displays data in rows and columns with summaries at the intersection points. To fully configure a Crosstab report, you'll also visit the Scope & Filters tab, and the Team tab.
The screenshot below is an example of a Crosstab report. The left-hand side can be a simple list, say of project titles, or can display up to 10 fields that are flat (directly related to the Topic) or hierarchical (children of the Topic plus their attributes). The fields from the Left Axis comprise a non-scrolling region. The Top axis is where you typically add the categories you There are three areas where you configure fields: the top axis, where you typically
How many columns/rows
Any project attribute and put it in the top or left axis. A 3rd attribute in the values field
Value field (attribute) must be numeric.
Adding Fields to Crosstab Reports
Top Axis - Can use up to 10 fields
Left Axis - Add fields
For Crosstab reports, you can displays grand totals and subtotals by choosing a position for the value(s).
To prevent display of totals/subtotals, choose None for the position.
You canOutline, Compact, or Tabular