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