Crystal Reports Xi - Sorting a CrossTab Report by a Summary Field

Question

So I have a simple crosstab report that calculates number of sales in the columns, and the rows are each office. The last column on the right is a total column, which contains a summary field (via a count of the identity field) that adds up the total number of sales per office.

How can I sort the crosstab data so the office with the most sales is the top row, and the rest in order under it?

Answer 1

Try this: Right-click on the crosstab. Go into the Group Sort Expert menu. There you will see options to display the top N rows, Sort All by the aggregate of a field of your choice, etc.

(I'm using Crystal XI. If your version is different, this may not work exactly)