- Launch Query Studio
- Query Studio High-Level Interface
- Report Types
- Open an Existing Report
- Create a List Report
- Run the Report
- Change Layout
- Create a Crosstab Report
- Create Filters
- Summarize Report
- Sort Data
- Create Calculations
- Create Charts
- Define Conditional Styles
- In a Nutshell: Reviewing by IBM Cognos BI Audience
This chapter is from the book
This chapter is from the book
This chapter is from the book
Create a Crosstab Report
Crosstab reports provide another perspective on the same data you see in the list report. You can use the Pivot option from the Change Layout menu or use the Pivot icon on the Standard toolbar to create a crosstab report, as shown in Figure 5.11. Notice in the figure that nested columns provide a wider perspective to the same data.
)
Figure 5.11. Create a Crosstab report via the Pivot option.
Click the New icon on the Standard toolbar to create a new report.
NOTE: This example uses GO Data Warehouse (query) package.
- Expand Retailers > locate Region.
- Click the Insert button.
- Ctrl+click Products > Product line, Product type.
- Ctrl+click Sales fact > Quantity and Revenue > click the Insert button.
Click the Region column > click the Pivot (Creates a Crosstab) icon on the Standard toolbar.
NOTE: The List report is now pivoted to a Crosstab report. The column you select when you choose Pivot becomes the column in the Crosstab. All measures are nested.
To switch the values currently displayed as rows to columns and columns to rows for another perspective of the data, you can use this option, as shown in Figure 5.12
Figure 5.12. Swap rows and columns.
Click the Swap Rows and Columns icon on the Standard toolbar.
NOTE: The rows become columns and columns switch to rows. The measures remain at the intersection.
)