Hiding columns in crosstabs

Users want to see sales figures by periods and order method. We need to show monthly sales and the yearly total sales. The year should be shown in the Year total row and not as a separate column.

Getting ready

Create a crosstab report with Sales fact / Quantity as a measure. Drag Time/Year and Month on rows, Order method / Order method type on column as shown in the following screenshot, and create aggregation on measure:

Getting ready

Add a total for the Month and Order method type then define appropriate sorting if required.

How to do it...

In this recipe, we want to hide the year from the crosstab and show it only in the report as a ...

Get IBM Cognos 10 Report Studio Cookbook - Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.