Cognos Report Studio Report Solution

[techieaman]

Hi All,

I need to find out how I can create the following crosstab structure in a report studio report:

Destination  PRODUCT                             Measure1         Measure 2          Measure 3

USA              Gamunxex(Level -3)
                    Plasmin(Levle-2)
                    Contract Mfg - Frac V(Level -3)
                    Contract Mfg - Other
                    Total Contract Mfg
                    TPR(Level - 3)
                    Royalties
                    Total Products

CANADA       Gamunxex(Level -3)
                    Plasmin(Levle-2)
                    Contract Mfg - Frac V(Level -3)
                    Contract Mfg - Other
                    Total Contract Mfg
                    TPR(Level - 3)
                    Royalties
                    Total Products

EUROPE         ,,

ALL               Totals

From my framework I have 2 tables destination with level and descr from 1-5. Product table with date levels from month to year, measures and Product levels from 1-5.

My problem is that Destination information to be shown is at Level 2 and the product structure has to be like the oen shown above. for sample I have put only a few items. But, many more products from different levels have to be put in a order(which is not sorted).

Can anyone suggest how do i accomplish this and group by each destination different products at different levels? and is this possible in a crosstab or do i need something put each calculation separately in table rows?

Please suggest a solution soon.

Thanks and Regards,

Aman