2 Either right-click on the data item, and select Add as Rank, or drag and drop the
data item onto the Ranks tab.
Set the parameters for the rank:
a Select the type of rank from the drop-down list. Top specifies that the rank
selects the greatest value. Bottom specifies that the rank selects the least value.
Specify the number of values for the rank. For example, if you specify 5, and you
select Top as the rank type, then the rank selects the five greatest values.
From the By drop-down list, select the measure that is used to create the rank.
You can either select any measure, or select Frequency to use the frequency of
the rank category.
Note: If you select a measure that is used in the current visualization, then the
rank uses the same aggregation for the measure that is used by the current
d (Optional) Select Ties to include ties in the rank.
If you select Ties, then the rank selects as many values as necessary to include
all of the ties. If you do not select Ties, then the rank selects only the number of
values that are specified by the rank parameters.
For example, if your rank selects the top three values, but there are five values
tied for the greatest value, then the number of values that are selected by the
rank depends on the Ties option. If you select Ties, then the rank includes all
five of the tied values. If you do not select Ties, then the rank includes only three
of the tied values.
Note: If the ranking does not select all of the tied values, or if the number of tied
values exceeds the maximum that is set by your administrator, then a message
Note: By default, your filter changes are applied automatically to the current
visualization. To apply multiple changes together, deselect Auto, and then click
Apply when you are ready to apply your filter changes.
Chapter 22 2 / / Working with Visualizations