This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am new to Alteryx and I don't understand how to sort numbers by Largest to Smallest within a column. I need 2 fields sorted Largest to Smallest, then after that, I need another column sorted Smallest to Largest to calculate a Multi-Row formula correctly.
Please note that there can be duplication's of all the numbers.
Local Member Firm Fees = Largest to Smallest
Other Member Firm Fees = Largest to Smallest
Opp ID = Smallest to Largest
See what the final example should look like attached:
First, I'd make sure your field types are all number format, so use a Select tool to check field types... then use the Sort Tool and start with the first column you want sorted (Opportunity ID) and sort Ascending... then the next line will be Local Member Firm Fees sorted Descending, and Other Member Firm Fees sorted Descending.