Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from wnash7658 on Jun 29 at 9:00 PM Not SD
| | | ---------------Original Message---------------
From: srinivasan_iyer
Sent: Monday, June 02, 2014 4:38 PM
Subject: Create a Specific Layout in Cross Tab Using Report Studio (levels)
Hi All,
First of i would like to thank in advance for anyone who is willing to help me.
I am an extreme novice in Cognos Report Studio and i am stuck with a dillema.
I would like to create the following report in Report Studio but have no clue as to how to create it. Below is the format i want the report to be in.
I get Productline Code,Month(Jan-14 etc), measure1, measure2, country(CANDA and USA) from a SQL query that i have written.
I have no clue as to what to do to get the below format into a crosstab and how i can achieve it.
Please help me by listing out how i can create the indentation and the % calculation since there are 10 productline codes and 12 months.
Productline Code
Measure1 Mesure2
Jan-14 X X
CANADA Y Y
USA Z Z
Canada% (X/Y)*100 (X/Y)*100
Feb-14 X X
CANADA Y Y
USA Z Z
Canada% (X/Y)*100 (X/Y)*100 |
| Reply to this email to post your response. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today.   _.____.__ |
