The Cognos Report Toolkit - Make crosstab with multiple measures as row

Check list of all posts

General note about The Cognos Report Toolkit

Report specification:  Relational, DMR, and Cube

Requirement

Below is a cross tab where multiple measures are aligned as row

Layout

Step 1: Create normal cross tab as below

Step 2: Drag planned revenue as nested node after Region

Step 3: Drag revenue as nested node under planned revenue after Region

Step 4: Drag gross profit as nested node under revenue after Region