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