IBM Cognos 8 Report Studio Cookbook

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. Hence, please use the "GO Sales SSAS cube" package which connects to the GO Sales cube for this recipe.

How to do it...

1. Create a new crosstab report.
2. Drag Current Year and Current Month on columns; and Organization Code 2 level on rows. Drag Stmt Year measure in the intersection.
   
3. Run the report to test it. The report will look like this.
   
4. Now we will try to filter the rows such that ...