HP Intelligent Management Center Standard Software Platform User Manual
Page 246
In such a case, you would select the sum or the average from this
drop-down list.
5.
In the Where N is text box, enter the number of groups you want to
display. For example:
•
To report on the three fastest selling product lines, set N to be equal
to three.
•
To report on the five least productive sales regions, set N to be equal
to five.
6.
Click the Include Others, with the name check box and enter a name
if you want to group all the other records into a single group.
7.
Select Include ties to accommodate groups whose summarized values
are equal.
For example, suppose you had the following groups:
•
Order 1 = 100
•
Order 2 = 90
•
Order 3 = 80
•
Order 4 = 80
If you set your top N to be three, but you do not select "Include ties," your
report will show Order 1, Order 2, and Order 3.
If, in the same scenario, you do select "Include ties," your report will show
Order 1, Order 2, Order 3, and Order 4 even though N is set as three. In
this way, the program accommodates the equal values of orders 3 and
4.
8.
Click OK when finished.
When the program runs the report, it will include only those groups that
you specified.
246
Crystal Reports 2008 SP3 User's Guide
Sorting, Grouping, and Totaling
10
Summarizing grouped data