movement of population

[#1]

Hi, i've made this table that shows the movement of the population of a client company in between two months

emp  cust_id         apr-11      mar-11

3011      89               1             0

3011      90                1             0

3011      91                1             0

3011      92                0             1

3011      93                0             1

3011       94                 1           1

this indicates that there are three people who are in apr11 and not in mar11 , there are two people who are not in apr11 but they were in mar11 and a person who is in mar11 and apr11

now i need to do this:

situation  apr11 vs mar11

emp      mov                      count

3011     IN                              3

3011      OUT                         2

3011    NO MOVE                 1                             

Is it possible? anybody can help me?

Thanks in Advance

[#2 · Accepted solution]

Hi Mario,

try this in the script:

num(MONTH(YM)) AS MonthC,

Sometimes in set analysis u have some problem with this thing.

It's better use month as number.

C u,

Stefano.

[#3]

chapeau !!!!

Grazie Stefano!