If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

wierd crosstab report

Started by dfite, 30 Oct 2008 03:10:06 PM

Previous topic - Next topic

dfite

Anyone know how to make a crosstab like the sample structure below?  I can do total monthly benefit (n) for years by Tier, but how do I add the Number of payees (p) and Average (q) fields below (n)?  What makes this harder is the years columns are user param values.  I am using cognos 1.1...  any advice?????

                   Years       5               10                15
Tier 1         
Total Monthly Benefits (N)   $11,000.50   $32,000.75   $53,000.50
Number of Payees (P)   100                200                300
Average (Q)                $110.00                $160.00                $177.67

Tier 1 Enhanced         
Total Monthly Benefits (N)   $11,000.50   $32,000.75   $53,000.50
Number of Payees (P)   100                200                300
Average (Q)                $110.00                $160.00                $177.67

Tier 2         
Total Monthly Benefits (N)   $11,000.50   $32,000.75   $53,000.50
Number of Payees (P)   100                200                300
Average (Q)                $110.00                $160.00                $177.67

Tier 3         

imts

I think using a CrossTab wont help u in ur case.
U can have multiple dimensions but u can only have one measure in a crosstab. And u want to measure N , P and Q.
U need to do it in a list (perhaps u have to modify it to suit ur need)