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: