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

Relative month calculations in crosstab report

Started by rameshB, 10 Feb 2014 08:43:33 AM

Previous topic - Next topic

rameshB

hello ,
I have policy count(cross tab intersection), lastday of the month (in row) and age of policy in row of crosstab.

I have data like below
Month end    0   1    total(age)
1/31/04   3   2        8
2/29/04   3   2       17

But I want to display the data in My report like below

Monthending    0     1
1/31/04         8     5
2/29/04        17     14
3/31/04       360     351
4/30/04       869     854

if age is then 0 I have policy count 8
if age is  1 then I have 5 policies 3 are lapsed at age=0
if age is 2 have 3 policies 2are lapsed at age=1  similarly for other months also.

How to achieve it?