Can anyone assist with this sql saved search expression? I'm trying to have 1 column list all the sales team members that have the same role. For example if we have multiple sales reps listed on the "SAles Team" of that opp I want it to be in one column instead of duplicating roles. I have this formula: CASE WHEN {salesteamrole.id} = 5 THEN {salesteammember} ELSE null END... However this is just repeating the same opp for all the different members that have that role

This is AWESOME! @Gregory Jones - thank you!

It's pretty neat! I've only used it a handful of times, but it's been really helpful to avoid having to export things and manipulate in excel