Group one field sort on another

[huddy33]

I have a report that is first grouped by type (i.e. speaker, client, etc). Once that grouping is performed, the end user wants the report to sort by email if the type is a client or to sort by affiliation if the person is a speaker.

I cannot figure out a way to force the sort by a non-grouped field and grouping by that field doesn't seem to work either.

Ideas?

it needs to look like this:

Speaker (group header - ordered by Last Name)

Bob Jones Private Practice
Sarah Thomas Zane Dental


Client (group header - ordered by email, ascending)
Amy Parker amyparker@email.com
Hannah Boden hboden@email.com

 

[Charliy]

Just create a formula {@sort2} that will be something like:

if {table.type} = "Speaker"
then {table.LastName}
else
if {table.type} = "Client"
then {table.email}

 

[huddy33]

Well holy cow, Charliy, that worked perfectly. I must have been making it harder than it seemed. Thanks!