COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: CCSlice on 27 Sep 2013 08:54:51 AM

Title: <SOLVED> Complex Crosstab
Post by: CCSlice on 27 Sep 2013 08:54:51 AM
Does anyone have a method in which I could display a report that summarizes two measurements under one heading?  I have dates that run vertically and employee job roles that run horizontally.   I tried using a crosstab report and finding it very difficult to summarize two metrics under the one job role.   Report Layout (attached)

Title: Re: Complex Crosstab
Post by: MFGF on 03 Oct 2013 08:55:13 AM
Hi,

This ought to be really easy. Just select your two metrics (Tasks Completed and Headcount) and drag them to the bottom edge of your job role column headings so that they are nested below.

Regards,

MF.