set analysis

[mambi]

Hello everyone ,

here's my problem : from the table below i want to have a straight table with months as dimension then calculate with set analysis the number of lost users per month.

USERID	MONTH-IN	MONTH-OUT
1	JAN
2	JAN	FEV
3	FEV	FEV
4	FEV	MAR
5	MAR
6	MAR
7	MAR

for this example i should get :

JAN	0
FEV	2
MAR	1

any idea?

[mambi]

Thanks a lot for your help Sir.