Cognos - Crosstab Report

Cognos – Crosstab Report

You’ll be prompted to pick the kind of report you wish to create. You might have choice to pick from totally different report varieties.

Blank

Choose Crosstab as sort of the report and click on OK.

The construction of a Crosstab report is opened as proven within the following screenshot.

Structure of Crosstab Report

Within the Insertable Objects pane, on the Supply tab, click on the information merchandise you wish to add to the crosstab and drag it to the Rows or Columns.

Source Tab

A black bar signifies the place you’ll be able to drop the information merchandise. Repeat the above given steps to insert further information gadgets.

You add dimensions to rows or columns and so as to add measures to the crosstab, drag the measures you wish to Measures.

Revenue

While you run the report, a crosstab report is generated that has one edge.

Formatting a Crosstab

You too can format the crosstab to present them look as per the requirement. While you specify formatting for all rows, columns, reality cells, or the crosstab, the formatting is robotically utilized to any new gadgets you add.

Crosstab Type order

While you apply kinds equivalent to font shade, rows and columns, intersections that is utilized within the following order.

  • Crosstab reality cells
  • Truth cells within the outermost rows
  • Truth cells within the innermost rows
  • Truth cells within the outermost columns
  • Truth cells within the innermost columns
  • Crosstab intersections

To do formatting of crosstab, click on anyplace within the Crosstab. Click on the choose ancestor button within the title bar of the Properties pane after which click on Crosstab as proven within the following screenshot.

Ancestor Button

Within the Properties pane, click on the property you need after which specify a price. For instance, if you wish to specify a background shade, click on on Background Shade and select the colour you wish to use.

Properties Pane

You too can right-click the row or column and click on Choose Member Truth Cells. Within the Properties pane, click on the property you need after which specify a price.

Select Member