Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here

Ranking Sales

8 - Asteroid

I have a dataset that shows the item type, country sold in, and dollar amount.

How can I rank each item by the country it was sole in and then by dollar amount?

13 - Pulsar

My personal preference would be to sort and then use the Multi-Row Formula tool.  Something along the lines of the attached.


Hope it helps!

8 - Asteroid

Thanks! I was sure mult-row formula would work, but I had no idea how to tell it to do what I needed.