...

NOTE. Nested groups should reflect the sort order. The outermost group header should be the highest priority sort, and the footer order should be reversed. Find more information on this Understanding Sorting and Grouping.

Sorting By Formula

To sort and group by information that may not be contained within an individual data field, you can use Formulas. See What are formulas for additional help.

Pressing the button or the Formula Editor () button opens the Formula Editor window:

...