COGNOiSe.com - The IBM Cognos Community

I have a need to display Site Information in the following manner,
SITE TYPE (LARGE, SMALL)
LARGE SITE #s (123, 234) and SMALL Site#s (012, 087)

So the Crosstab will look like

First Row:                LARGE                |           SMALL
Second Row:           123  234             |      012  087
Third Row (Count)    1       9               |        1       11

I tried using the Customize Grouping on the Site #s and created the LARGE and SMALL groups. But everytime I drop the
site# as a data item to the Crosstab, the GROUPING is take over. So I am getting only

First Row:                LARGE                |           SMALL
Third Row (Count)    1       9               |        1       11

without the second row. I CAN'T even create Section from the Data Item so it would break the rows down as following,
Report Listing Breaking based on the Section established,

First Row:                LARGE               
Second Row:           123  234           
Third Row (Count)    1       9     

First Row:                SMALL               
Second Row:           012  087         
Third Row (Count)    1       11     

Any help will greatly appreciate it.
Thx :)

so basically I'm trying to have a separate row under the Crosstab Node Member. please see attached.

First Row (Node Member):                LARGE       |     MEDIUM               
Second Row (Dropped Data Item       9| 8 | 7            |4  |5   |6           
Third Row (Count)                              1| 2 |100           20 |40 |60

Using the set defenition, I established the Customized Grouping for LARGE and MEDUIM. it is doing
what it suppose to do. Then I created a data item and dropped it under this Crosstab Node Row, so the second grouping of sizes will be shown but no luck!! it stays with the first grouping since the dropped data item is based on the same item that has the GROUP customization of LARGE and MEDIUM.

Please HELP!!!

You may get  better response by pointing out whether you are reporting on a relational of dimensional package..

This grouping need using Crosstab is related to Dimensional Package where there is Dimension-Hierarchy-Level exists for the members.

Some Success using the below procedue,

• I created the Groups using Group Customization option for the Top Row of the Crosstab. Works great!
  For the second Row, here is what I did,
  I created a separated Data Item from the same exact member.
  I dragged/dropped this new Data Item to underneath the Crosstab Top Node Member to create the second grouping.

Now, the First Row is showing the           LARGE        |     MEDIUM
and Second Row is showing the Sizes      9| 8 | 7            |4   |5   |6     
and of course the bottom Counts are showing properly.

Please confirm my work if you don't mind and let me know why it is running so slow?

Thx in advance for your time.