Skip to main content
Planview Customer Success Center

Crosstab Reports (Beta)

[under construction]

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.

Overview

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

crosstab.png

Display Tab

2020-05-07_18-37-31.png

For Crosstab reports, you can displays grand totals and subtotals by choosing a position for the value(s).

  • For row totals, First position places the grand/sub total at the far left of the grid, in the first column. Last position places the grand/sub total at the far right of the chart, in the last column.
  • For columns, First position places the grand/sub total at the top of the grid, in the first row. Last position places the grand/sub total at the bottom of the grid, in the last row.

To prevent display of totals/subtotals, choose None for the position.

You canOutline, Compact, or Tabular