HP Intelligent Management Center Standard Software Platform - Manual (Page 244)

In such a case, you would select the sum or the average from this
drop-down list.
5. Specify the sort direction.
6. To select a second group sort, repeat Steps 2-5.
When you run the report, the program will order the groups based on the
summary value(s) specified.
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. Because this kind of selection is so popular, the program includes the
Group Sort Expert for setting it up easily.
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 need to decide whether to eliminate those records
from your report entirely or to lump them all together into a single group. The
program enables you to choose either option.
Note:
• A report must contain a summary value in order to be able to perform a
top N or bottom N selection. See
Summarizing grouped data .
• It is recommended that you do not use a group that is sorted hierarchically
in a top or bottom N selection. The integrity of your hierarchical group
sort might be affected by the top or bottom N selection.
To select the top or bottom N groups
Note:
This procedure shows you how to select top or bottom N groups. Top or
bottom percentages work the same way except that you define the percentage
value instead of the number of groups.
1. Create a report and summarize the data as desired. When you summarize
the data, the program breaks the data into groups and summarizes each
group.
244 Crystal Reports 2008 SP3 User's Guide
Sorting, Grouping, and Totaling 10
Summarizing grouped data