In a saved search, I am trying to return the roster of certain team roles in columns rather than rows. For example, for a given customer, I'd like to have a 'Sales Rep', 'Account Manager' and 'Project Manager' column that fills out each column result with that particular role. This logic does not seem to work: CASE WHEN {salesteamrole}="Account Executive" THEN {salesteammember} END Any ideas on how to make this work?

your double quotes should be single quotes. does that work?

you might try decode instead

Decode({salesteamrole},'Account Executive',{salesteammember})

Thanks -- both methods worked. And derp on me for having the double quote in the original CASE statement. It is insisting on dropping each result in a single line, but I will tackle that after lunch.

You'll have to group your search by customer