CODEWITHSUNDEEP
crystal-reportsbusiness-objects
Albert
Albert

Reputation: 3689

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

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?

Upvotes: 1

Views: 6266

Answers (1)

PowerUser
PowerUser

Reputation: 11791

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)

Upvotes: 6

Related Questions