Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I guess you are trying to match the Base_1 that fall between from and to base. If so, you need to use Interval Match