9 Replies Latest reply on Feb 14, 2017 5:19 AM by Norbert Maijoor

    How to make price ladder per category

    Stefan Stoian

      hi,

      I have a situation where I have to create price ladders per product and per category of products.

       

      i.e.

      - the ladders might be low, medium and high;

      - each product has 5 levels of category

      - I want to see in level 2 where the price of the product is situated

       

      low means 0.7*average price of Level 2

      high means 1.3*average price of Level 2

      medium is the rest of the population

       

      In my attached example I want to find out in the category "yellow cheese" how each item is classified.

       

      LMH.PNG

      Thanks guys,

      Stefan