Wednesday, April 17, 2013

The Cognos Report Toolkit - Make summary on the top for Crosstab

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

Below is a cross tab where all totals are located on top


Layout


Step 1: Create normal cross tab as below

Step 2: highlight region, product line and product type, then click Automatic summary

Step 3 Drag Summary (region) on top of region

Step 4 Drag Summary (Product line) on top of product line, and Drag Summary (Product Type) on top of product Type
Posted by at
Labels:

2 comments:

  1. AnonymousMay 29, 2013 at 6:54 AM

    Do you plan on publishing a book? You should do as your blog is by far the best resource online for Cognos reporting.

    ReplyDelete
  2. AnonymousJune 27, 2013 at 1:15 AM

    Impressive work Sir....Take a Bow... for all your posts..:-)

    ReplyDelete

Subscribe to: Post Comments (Atom)