1 2 3 4 5 6 7 8 9 10 11 12 13 14
| CASE WHEN "Fact Sales"."Order Created by" IN ('NADIA','GILLIANE','STEPHANE','CARINE','NADINE','SANDRA')
THEN 'Service Clients'
WHEN "Fact Sales"."Order Created by" IN ('SANDRA','FABIENNE')
THEN 'Service Depots'
WHEN "Fact Sales"."Order Created by" IN ('LAURENT','FRANCOISE','SYLVAIN')
THEN 'SAV'
WHEN "Fact Sales"."Order Created by" IN ('ALAIN')
THEN 'ALAIN'
WHEN "Fact Sales"."Order Created by" = 'JEROME'
THEN 'JEROME'
WHEN "Fact Sales"."Order Created by" = 'OPHELIE'
THEN 'OPHELIE'
ELSE NULL
END |