Limiting Sort Field Values

In a sort phrase, you can restrict the number of sort values displayed. With the PLUS OTHERS phrase, you can aggregate all other values to a separate group and display this group as an additional report row.

The format of the PLUS OTHERS phrase is as follows:

[RANKED] BY {HIGHEST|LOWEST} n sort_field [AS 'text']
[PLUS OTHERS AS 'othertext']

To display the top two ED_HRS values and aggregate the values not included in a row labeled Others, issue the following request:

TABLE FILE EMPLOYEE
PRINT CURR_SAL LAST_NAME
BY HIGHEST 2 ED_HRS
PLUS OTHERS AS 'Others'
END

Run the request. The output is:

	WebFOCUS