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

Description Parameter
Ranking order.
Top - ranks in descending order.
Bottom - ranks in ascending order.
Top/Bottom
The number of records to return in
the ranking. For example, the top 10.
Number of records
The object used in the ranking. For
example, if the object is Region and
the ranking is Top 10, the ranking
returns the top 10 regions.
Ranking object
The measure by which the ranking
object is ranked. For example, if the
measure is Revenue and the object
is Region, Crystal Reports ranks re-
gions by the amount of revenue they
generate.
Based on
The object that specifies additional
calculation context for the ranking.
For example, if the ranking object is
Region, the measure is Revenue and
the For Each dimension is Country,
Crystal Reports ranks regions by
revenue within each country.
For Each (optional)
482 Crystal Reports 2008 SP3 User's Guide
Building Queries 18
Filtering data using subqueries and database ranking