robert fuschetto Posted October 26, 2021 Share Posted October 26, 2021 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! Link to comment Share on other sites More sharing options...
robert fuschetto Posted October 26, 2021 Author Share Posted October 26, 2021 I needed to click the column then RANK above. Link to comment Share on other sites More sharing options...
SATHEESH B Posted October 26, 2021 Share Posted October 26, 2021 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` Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now