Hello community !
Here is the new challenge !
I have a data base with:
- “WareHouse”
- “Product Family”
- “Product”
- “Volume”
I need to assign a note to the products from 1 to 3, 3 being the best.
Relatively to “Warehouse”" and “” Family Product"
I have to compare the product Volume and rate them this way:
Rating from 1 to 3: Sorting them from bigger to smaller in volume.
-
20% of product of theses Product Family and Warehouse that make 50% of volume of this Product Family and Warehouse --> 3
-
30% of product of theses Product Family and Warehouse that make 30% of theses Product Family and Warehouse volume --> 2
-
50% of products of theses Product Family and Warehouse that make 20% of volume --> 1
WareHouse Family "Product Volume
A 1 x 1
A 1 y 2
A 1 z 3
A 2 s 1
A 2 t 2
A 2 u 3
B 1 x 1
B 1 y 2
B 1 z 3
B 2 s 1
B 2 t 2
B 2 u 3
Thank you in advance !