I don't know if this is possible at all... however unfortunately my script doesn't do the trick.
While LOADing a CROSSTABLE I would like to add a column which contains values based on a CASE check. My script looks like the following:
CROSSTABLE (A, B, 11) LOAD year,
CASE WHEN "Emp.-No."<1000
CASE WHEN "Emp.-No.">=1000 AND <2000
END as "Group",
Am I following the wrong approach to this or is this an abuse of the syntax?? 
Any help is highly appreciated!! Thanks in advnace