2 Replies Latest reply: Mar 14, 2017 8:30 PM by Marco Wedel RSS

    interval in dimension

    Giuliano Beltramello

      Hello

      I have this problem:

      - a list of personalized products with different width  (i.e. 3 products that are 751 mm width, 83 products that are 749 mm width, 7 products that are 832 mm width and so on) .... this dimension is called BASE_1;

      - in the second column I have the quantity ... QTY.

       

      I would like to totalize the column ' QTY' (sum) grouping the width in this way:

      from     to

      0          750

      751      850

      851      950

      951     1050

      >=1051

       

      i tried the functions pick and class, but I'm in a lot of trouble.

      Any help

      thanks

      g