Yes, you can do it in derived column. what you need is a bit more cumbersome than what I would want to do in a dc, but if you can't do it in source query and don't have a script component onboard already, use derived column.

I stumble around with the syntax in them, so I suggest you build one little case at a time to get their syntax correct then join them up with the appropriate ands/ors.

Do keep in mind that you are confined to the functions and operators that display top right in the component.