
Re: Pivot Tables & Set Analysis: Survival Triangles
Kevin Flynn Jan 24, 2013 1:21 PM (in response to Kevin Flynn)Specifically, I think I want the result when terms survived = 3 to be:
sum of ( all quarters at terms = 0 where (terms = 3 =/= 0))
if that makes more sense.

Re: Pivot Tables & Set Analysis: Survival Triangles
Kevin Flynn Feb 27, 2013 6:10 PM (in response to Kevin Flynn)Wound up doing it the ugly way. Got the denominator with:
if(terms_survived = 0, rangesum(last(sum({$<cohort2 = {"<=20"}>} ind),1,21)),
if(terms_survived = 1, rangesum(last(sum({$<cohort2 = {"<=19"}>} ind),1,21)),
if(terms_survived = 2, rangesum(last(sum({$<cohort2 = {"<=18"}>} ind),1,21)),
if(terms_survived = 3, rangesum(last(sum({$<cohort2 = {"<=17"}>} ind),1,21)),
if(terms_survived = 4, rangesum(last(sum({$<cohort2 = {"<=16"}>} ind),1,21)),
if(terms_survived = 5, rangesum(last(sum({$<cohort2 = {"<=15"}>} ind),1,21)),
if(terms_survived = 6, rangesum(last(sum({$<cohort2 = {"<=14"}>} ind),1,21)),
if(terms_survived = 7, rangesum(last(sum({$<cohort2 = {"<=13"}>} ind),1,21)),
if(terms_survived = 8, rangesum(last(sum({$<cohort2 = {"<=12"}>} ind),1,21)),
if(terms_survived = 9, rangesum(last(sum({$<cohort2 = {"<=11"}>} ind),1,21)),
if(terms_survived = 10, rangesum(last(sum({$<cohort2 = {"<=10"}>} ind),1,21)),
if(terms_survived = 11, rangesum(last(sum({$<cohort2 = {"<=9"}>} ind),1,21)),
if(terms_survived = 12, rangesum(last(sum({$<cohort2 = {"<=8"}>} ind),1,21)),
if(terms_survived = 13, rangesum(last(sum({$<cohort2 = {"<=7"}>} ind),1,21)),
if(terms_survived = 14, rangesum(last(sum({$<cohort2 = {"<=6"}>} ind),1,21)),
if(terms_survived = 15, rangesum(last(sum({$<cohort2 = {"<=5"}>} ind),1,21)),
if(terms_survived = 16, rangesum(last(sum({$<cohort2 = {"<=4"}>} ind),1,21)),
if(terms_survived = 17, rangesum(last(sum({$<cohort2 = {"<=3"}>} ind),1,21)),
if(terms_survived = 18, rangesum(last(sum({$<cohort2 = {"<=2"}>} ind),1,21)),
if(terms_survived = 19, rangesum(last(sum({$<cohort2 = {"<=1"}>} ind),1,21)),
if(terms_survived =20 , rangesum(last(sum({$<cohort2 = {"<=0"}>} ind),1,21)),
)))))))))))))))))))))