Hiding column in crosstab
Users want to see sales figures by periods and order method. We need to show monthly sales and year's totals. 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 dimension | Current year and Month on rows, Order method | Order method on column as shown in the following screenshot. Create aggregation on measure.
Define appropriate sorting.
How to do it...
- First, let's identify the issue. If you run the report as it is, you will notice that the year is shown to the left of the months. This consumes one extra column. ...
Get IBM Cognos 8 Report Studio Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
