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

Cross Tab Report Issue

Started by engsonu, 25 Oct 2012 06:49:30 AM

Previous topic - Next topic

engsonu

I have to develop below crosstab report.
                 
Outstanding Claims            Current                   1 month old             2 months old           3 months & older          Total Outstanding
average 2008                          248                           87                              46                                 19                      400
average 2009                          216                           99                              56                                 25                      395
average 2010                          145                           62                              15                                  3                       225
average 2011                          123                           60                              11                                  2                       196
average 2012                          103                           45                               8                                   2                       157

current  - average of total number of claim which are open for 0-30 days

Business logic for the report:
Claim Age = Claim last Updated Date – Claim Filed on Date
Claim Filed on date should be before Report run date.

Claims which are open for 0-30 days will be under Current Column,
Claims which are open for 31-60 days will be under 1 Month old.
Claims which are open for 61-90 days will be under 2 Months old.
Claims which are open more than 91 days will be under 3 Months & older.

Report Run Date is 25th of every month.

I have to calculate total number of claims every month for each section (current,1 month older....)

Can anybody help how to do this?