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?