...
To add a sort formula, click Add Formula, then use the formula editor to make a composite field to sort on.
...
You may want to sort groups by the summary, or aggregate, calculation of each group. You can do this using Top/Bottom filters.
Top/Bottom filters look for the highest or lowest values in a set, and then put those values in order. You can supply any arbitrary cell in the report in the Top/Bottom filter. So if you set the number of displayed values to "infinity", then no values are excluded, but the ordering still takes effect.
...
To hide or show all the rows in the ExpressView:
 | Click the Group Expand/Collapse Options icon. |
 | Click the Hide All Group Content to hide all the rows. |
 | Click the Show All Group Content to show all the rows. |
If you have nested groups, this hides all but the top level groups.
...