IBM Cognos 10 Report Studio Cookbook - Second Edition

Filtering rows or columns

This recipe will show you how to filter row or column members in a crosstab report.

Getting ready

This report will be based on the dimensional source. Therefore, please use the Sales and Marketing (cube) package for this recipe.

How to do it...

In this recipe we will see how to filter the report by hiding the empty rows as follows:

1. Create a new crosstab report.
2. Drag Year and Month onto columns and Retailer name onto rows. Drag the Revenue measure onto the intersection:
   
3. Run the report to test it. The report will look as follows:
4. Now we will try to filter the rows so that only retailers that have data are displayed. For that, delete ...