I'm trying to use a quick filter to select sales people associated with specific branches. There is some overlap in assignment, in other words two branches are assigned to two different people. Here is my current case statement:
case
when `Customer Home Branch` IN ('207500','208500') then 'Brad'
when `Customer Home Branch` IN ('203500','207500','208500') then 'Scott'
end
Here is a video overview of the question I am asking.
Thanks in advance!