How to track member status change .... Urgent help required !!!

[#1]

Hi Guys ,

I am attaching file where input fileds are Mbr_Code, Month , Tier . And i need to create Output_1 & Output_2 .

Output_2 applicable only when member changes its status from " Base ----> silver -----> Gold " in one month .

Apprciate if someone can qiuckly guide me in this ...

Mbr_Code	Month	Tier	Output_1	Output_2 (only for monthly change from base to gold)
A_001	Jan	Base	-	-
A_001	Feb	Base	-	-
A_001	Mar	Base	-	-
A_001	Mar	Silver	B_S	-
A_001	Mar	Silver	-	-
A_001	Apr	Silver	-	-
A_001	May	Silver	-	-
A_001	Aug	Gold	S_G	-
A_001	Aug	Gold	-	-
A_001	Aug	Gold	-	-
A_002	Jan	Base	-	-
A_002	Feb	Base	-	-
A_002	Mar	Base	-	-
A_002	Mar	Silver	B_S	-
A_002	Mar	Gold	S_G	B_G

Regards,

Bhushan N

[#2]

Hi Bushan,

Do you need to create the "Output 1" based on the "Tier" column and then the "Output 2" based on "Output 1"?

and Does "Output 1" will have only 3 values either "-" or "B_S" or "S_G" ?

[#3]

Hi Srini ,

Please find reply for your quries :

Do you need to create the "Output 1" based on the "Tier" column and then the "Output 2" based on "Output 1"? ---- > Yes . In output_2 column i need to mark only when member changes its status from Base---> Silver ---> Gold.

and Does "Output 1" will have only 3 values either "-" or "B_S" or "S_G" ? ----> Yes

The whole idea here is to identify , at any particular month how many members changes there status & categories are

1) Base --> silver

2)silver---> Gold

3) base---> Silver----> Gold

If there is any other approach forthis thenm please let me know.

Regards,

Bhushan n

[#4]

Hi Bhushan,

see the attached example for an idea to get OUTPUT_1.

Good luck!

Rainer