Download BusinessObjects User's Guide

Chapter 12 Organizing Data in Reports
Example
Show sales revenue for top three months and compare with overall revenue
............................................................
This report displays the top three revenue-making months. It shows the
combined revenue for September, January and March (Sum) and the total
revenue for the other nine months of the year (Sum Other).
............................................................
Tip: To remove the ranking, click inside the ranked data, then click the Apply
Ranking button.
Altering values for an existing ranking
Once you have defined a ranking by specifying the ranking values you want to
display, you can edit it by selecting different ranking values. For example, if you
have applied a ranking that enables you to view the top and bottom 3 ranking of
revenue for customers, you can edit the ranking to show the top 10 instead.
To select different values for an existing ranking:
1. Click inside the data where the ranking was applied.
2. Select the Ranking command on the Format menu.
The Select Top/Bottom Variable Name dialog box appears, with the current
ranking options selected.
3. Alter the ranking settings as desired, then click OK (or Apply). When you exit
from the Dialog box, the values with the new ranking criteria are displayed.
Removing a ranking
When you remove a ranking, all the data on which you applied the ranking that
may have been suppressed by the ranking criteria re-appears in the report. For
example, if you applied a ranking that displays the top 10 customers by revenue,
then you remove that ranking, the data for all customers is displayed.
276 BusinessObjects User’s Guide