Saturday, November 30, 2013

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

General note about The Cognos Report Toolkit
Report specification:  Relational, DMR, and Cube

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


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

1 comment:

  1. Please..Can you add instructions to this post on how to summarize the 3 measures in the rows on the summary line?!