Home  >  Blog  >   IBM Cognos

Working With Cross Tab Reports In Cognos

Rating: 5

Cross Tab reports :

Crosstab reports provide another perspective on the same data you see in the list report. It show information in a more compact form than in a grouped list.

They are dimensional objects that have row edges and column edges. Each edge is composed of a set of crosstab nodes. Each crosstab node contains the following:

  • One or more crosstab node members.
  • Zero or one nested crosstab node, which contains one or more crosstab node members or nested crosstab nodes.

A crosstab report shows a measure at the intersection of each row and column.

Enroll for Instructor Led Live Cognos Training Online

This is useful for showing more information in a smaller area.

For example, if a report shows Product line as columns, Country as rows, and Quantity as the measure, the value at the intersection of each column and row shows the quantity of units sold for that product line and that country.

Cross Tab reports

  • Cross tab reports are the best reports for the comparative analysis
  • Each and every cross tab contains rows, columns, measure zones
  • There are 4 types of cross tabs

1) Basic CrossTab

Total )
Order year (Column )
—————————————————————————— Product Type(Rows)                            Revenue (Measure) (

2) Nested Cross tab

on columns)
Product Line (Nested
Product Type
Order year, order month                                         Quantity (Measure ) (Nested on rows)                        (Total )

3) Union Crosstab:

Product Type
Product Line(Total),
(Union on columns)

Order Year, Order Method                                          Revenue

(Union on rows)                                                   ( Measure)

  • Drag and drop crosstab space from toolbar between Product Line, Product

Type between Order Year and Order Method

MindMajix Youtube Channel

4) Asymmetric Crosstab reports:

1 , 2                                                        5

Asymmetric Crosstab
Asymmetric Crosstab 1
Asymmetric Crosstab 2
Asymmetric Crosstab3
Asymmetric Crosstab4
Asymmetric Crosstab5

Explore Cognos Sample Resumes! Download & Edit, Get Noticed by Top Employers!Download Now!


Join our newsletter

Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!

Course Schedule
IBM Cognos TrainingSep 26 to Oct 11View Details
IBM Cognos TrainingSep 30 to Oct 15View Details
IBM Cognos TrainingOct 03 to Oct 18View Details
IBM Cognos TrainingOct 07 to Oct 22View Details
Last updated: 24 September 2023
About Author

Ravindra Savaram is a Content Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.

read more
Recommended Courses

1 / 15

Try NOW: One-Access by MindMajix