In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Ranking Sales

jonathangonzales
8 - Asteroid
‎12-05-2017 08:11 AM

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?

Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
danrh
13 - Pulsar
‎12-05-2017 08:34 AM

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!

Rank by Country.yxmd
Reply
jonathangonzales
8 - Asteroid
‎12-05-2017 10:25 AM

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

Reply
0 Likes
Fall Release Webinar
Alteryx One Admin Experience
Labels
Top Solution Authors
View All