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 - plz help

Started by dfite, 30 Oct 2008 03:27:22 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