Hi All,

I want to create a formula for a table that looks like this:

ID UDOfficer DATE
1   6          Jan
1   7          Jan
1   9          Jan
2   6          June
3   6          April
4   6          May
5   5          Dec
6   7          Nov
7   6          April
7   4          April


What I want to create is a formula to put in a crosstab to capture UDOfficer = 6 and all others, but if UDOfficer is in 6, 7 and 9, the all others can not count that ID that was already counted for UDOFFICER 6.

OUTPUTCrosstable

DATE   UDOFF6   UDOFFOTHER
JAN     1            0
APR     2            0           
MAY     1            0
JUN     1            0
NOV     0            1
DEC     0            1       

Edited by Fuonge - 10 Dec 2014 at 7:50am