Create Specific Rank

[SebSchoon1]

Hi Guys,

Need challenge for you today! 

I have this Table 

I'd like to Split one available (which is in [Stock]) quantity by [CODE ARTICLE] 

However i Have 3 Sizes with Each One quantity in stock.

So one of each Size Must go to one unique warehouse! 😛 

I'd like to Create an Index Based on each [TAILLE] associated to each [CODE ARTICLE]

So i could Share 1 quantity By [TAILLE] Rank   for Each [Rank] by Warehouse !

Any way to achieve this?

Here is the link to download my sample.

https://we.tl/t-9CoSQ8NHkq

Thanks guys you roxx!!

[v-jingzhang]

Hi @SebSchoon1 

Can you share the expected rank result along with the sample data? Currently I have difficulty understanding the expected result. I don't see "Size" and "Warehouse" in the data.

Best Regards,
Community Support Team _ Jing

[SebSchoon1]

Hi @v-jingzhang ,

Hope you are well today!

Here is my expected result

= )