I'm aiming to match the final sorted state of data displayed in the new image I've uploaded. To sort data to match this final state in Alteryx, I've use the Sort tool with the following configuration:
Annual Transactions: Descending
Upon comparing the provided screenshots of the sorted data, I see that there is a discrepancy in the order of 'Customer_ID' 787 in the two sets of results. In the correct order (My results), 'Customer_ID' 787 should be listed as the last record because it has the lowest number of 'Annual Transactions' (86), and the other sorting criteria ('Annual Transactions') do not affect its position due to it being unique in this subset.
I have checked the data type, and the data type is V_string. After making any necessary changes, re-run the workflow and check the results again. How can I sort data and optain the Final State print screen?
Annual Transactions - DESC
Customer ID - ASC
Zip - ASC
Store Number - DESC
Try this?