I have a file of data sorted by Dept and Count of Widgets. ...

[robert fuschetto]

I have a file of data sorted by Dept and Count of Widgets. there are hundreds of rows but I only want the TOP 20. How do I do that in the GUI or Code it. What happens if there are ties Thanks!

[robert fuschetto]

I needed to click the column then RANK above.

[SATHEESH B]

You can use in the BY field . HIGHEST OR LOWEST 20 .

`> TABLE FILE WF_RETAIL_SALES

 

SUM

WF_RETAIL_SALES.WF_RETAIL_SALES.GROSS_PROFIT_US

BY HIGHEST 10 WF_RETAIL_SALES.WF_RETAIL_SALES.ID_PRODUCT

ON TABLE SET PAGE-NUM NOLEAD

ON TABLE SET ASNAMES ON

ON TABLE NOTOTAL

ON TABLE PCHOLD FORMAT HTML`