CASE Statement multiple rows in results
I have a saved search where I need to display both the Sales Rep and the Sales Support personnel on each company record. I used CASE statements to narrow down which sales team role should populate into each column, but my results now display one row for the sales rep and another row for the Sales Support personnel. How can…