Crystal Reports for Eclipse Designer Guide

Selecting top or bottom N groups or percentages

At times, you might want to show only the top or bottom groups, or percentage values in a report: the fastest selling product lines, the countries that account for the top 25 percent of sales, the states that generate the most orders, and so on.
There is one other element to consider when setting up top N: what to do with all the records from other groups that do not fit the top N or bottom N criteria you have set. You can eliminate those records from your report entirely or collect them into a single group. The program lets you choose either option.
Note: