Cohort analysis in a crosstab

[isilvera]

Hello Comunity,

I would like the numbers in the blue thing to be where it is null so it follows the logic of the cohort analysis. If you do have any clue on how to perform this, please help.

This is how the raw data looks.

Thanks!

[RishiK]

Hi there

Prior to crosstabbing your data (I assume you are referring to the Value column - in the Crosstab tool itself to populate the values), you just need a formula in a Formula tool to check if the Value column is null, then populate the Value column with the ACC_NO_START DATE Value.

Then you can crosstab as you would 

[isilvera]

Hello I used this formula:

IF IsNull([Row-1:Value])
and [Row-1:ACCT_NO_START DATE]=[ACCT_NO_START DATE]
and [Row-1:Card Start Date (2)]=[Card Start Date (2)]
and [Row-1:COMPANY]=[COMPANY]
and [Row-1:ACCOUNT_TYPE]=[ACCOUNT_TYPE]

THEN [ACCT_NO_START DATE]
ELSE [Row+1:Value]+1
ENDIF

But it just worked for the first rows, then, it does not: