Conditional Pareto analisis

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 !

Hi Yacine!

I understand I am replying to a very old post… recently I had a similar problem and I figured out a solution. I had finally the time to put it on the hub

Hope it helps

Ludovico

1 Like