Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do I display only the first Top 10? 1
- Thread starter Enea
- Start date
-
1
- #2
BrianTyler
IS-IT--Management
Enea
If the numbers are measures, you can use the RANKING tool.
This is the 'winners platforms' in the toolbar (next to the alerters triangle).
Choose the dimension you wish to rank and the number of occurrencies you wish to see, and then tell the tool which measure to use for the comparisons.
For example, to find the highest paid employee, you will RANK the EMPNO based on the measure SALARY.
If the number is not a measure, create a new variable equal to the number field, and define this as a measure. You need not include it in the report layout, but you will be able to use it as the ranking variable.
Brian
If the numbers are measures, you can use the RANKING tool.
This is the 'winners platforms' in the toolbar (next to the alerters triangle).
Choose the dimension you wish to rank and the number of occurrencies you wish to see, and then tell the tool which measure to use for the comparisons.
For example, to find the highest paid employee, you will RANK the EMPNO based on the measure SALARY.
If the number is not a measure, create a new variable equal to the number field, and define this as a measure. You need not include it in the report layout, but you will be able to use it as the ranking variable.
Brian
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question