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
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)