Sorting by Multiple Fields in Reports

Is there a way to sort by multiple columns when creating a Row & Column Report?

For example, we would like to sort a Row & Column report of our open Opportunities by

1) Account Name (alphabetically) and

2) Opportunity Name (also alphabetically)

so that our Opportunities are grouped first by Account but also by name. From what I've been able to find I can only sort by one column at a time; is there any way around this?

Parents

0 André Lopes over 5 years ago

Unfortunately regular Reports only support a single field for sorting. On Advanced Report you can do anything you want.

André Lopes
Lampada Global

Skype: andre.lampada
0 Tim Miller over 5 years ago in reply to André Lopes

Got it, thanks! Although I'm having trouble pulling fields I made in studio as part of the Custom Query under the Advanced Reports. Every time I add the field name to the query, I receive a message saying it's invalid. Can I only run Custom Queries using out-of-the-box fields?

Reply

0 Tim Miller over 5 years ago in reply to André Lopes

Got it, thanks! Although I'm having trouble pulling fields I made in studio as part of the Custom Query under the Advanced Reports. Every time I add the field name to the query, I receive a message saying it's invalid. Can I only run Custom Queries using out-of-the-box fields?

Children

No Data