COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: PlayCognos on 21 Aug 2008 02:06:42 PM

Title: Multiple detail data in cross-tab report???
Post by: PlayCognos on 21 Aug 2008 02:06:42 PM
I would like to have a report in the following format using Report Studio cross-tab:


___________________________________________________________________________________________________
Sales   |                      North Zone               |                     South Zone
________|__________________________________________________________________________________________
        |     # of transactions   | Total Sales in $    |     # of transactions   | Total Sales in $
________|_________________________|________________________________________________________________
FY2008  |               160                $23,434,534  |               156                $11,222,333
FY2007  |               145                $20,345,211  |               122                $23,344,555
FY2006  |               127                $19,111,222  |               134                $34,654,345
________|__________________________________________________________________________________________



Is this possible?

Thank you in advance
PC
Title: Re: Multiple detail data in cross-tab report???
Post by: rockytopmark on 21 Aug 2008 03:26:19 PM
100%
Title: Re: Multiple detail data in cross-tab report???
Post by: PlayCognos on 21 Aug 2008 03:46:33 PM
Would you please be able to provide some details on how to?

Thank you.

PC
Title: Re: Multiple detail data in cross-tab report???
Post by: imts on 22 Aug 2008 04:09:26 AM
Please find attached a sample report which is similar to your requirement.

Regards,
Tarun