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 attempting to populate the "Rank" field in column E below within Alteryx. I would like to rank values in column D based upon the values in columns A and B. This has proven to be challenging, since the ranking needs to be dynamic due to salespeople in column B overlapping regions.
For example, I need to rank which items Mike Smith sold the most of within the Northeast region. For Sue Johnson, I not only need to rank which items she sold the most of in the Midwest, but also how much she sold in the East region.
Does anyone know of a way to accomplish this in Alteryx? Or is there a different work-around for this? Seems like it would be a fairly-common function, but I cannot seem to find any way to get this to work.