Sorting on Multiple Factors and Within Groups

shelbybradley

I am having trouble sorting values based on multiple factors of priority, and then sorting within groups.

Context: 

- I want to set an overall rank of priority on a product-customer level based on a set of prioritizations. Ultimately, I want to calculate how much revenue I can satisfy given my supply constraints in this scenario.

My order of sorting priority is: 

1. Product is demanded by Amazon (Yes or No)

2. Products with the highest overall $ Demand (among all customers), descending order

3. Customers the the highest $ demand, within each product group, descending order. 

My questions are: 

1. How do I sort on multiple factors sequentially so that they all remain intact?

2. How can I sort values with a particular group ( addressing the third prioritization factor ) so that I can order customer demand within each product? - again, without disturbing the first two sort factors

I have attached an example data set that shows product, customer, and demand.

THANKS

Illustrative data.xlsx

atcodedog05

Hi @shelbybradley 

You would need to handle 1st, 2nd as one and 3rd criteria separately. Handling it together might not give you the desired output.

1. Product is demanded by Amazon (Yes or No)

2. Products with the highest overall $ Demand (among all customers), descending order

As you can see below after above 2 sorts Product shirt is spread out since there is a higher sort there is no way to bring shirt together.

3. Customers the highest $ demand, within each product group, descending order. Here first 2 are broken.

If you have a specific idea of output in mind share with us we can try to achieve it.

Hope this helps : )

shirts.yxmd