Hi guys,
I'm wondering if there is a simple way to compare 2 data items (say weight and width) and choosing just the lowest of the 2, but putting it into a separator, for example:
item weight width
box1 10lbs 20cm
box2 12lbs 10cm
etc
I would want box 1's width value, but box 2's weight, then put into a category like:
segments total # of items
between 1-5 1
between 6-10 5
between 11-20 11
so basically I was looking for a way to go through and compare 2 values of something and take the lowest value, and then use that in a cumulative value afterwards... if that makes sense...
I was trying something with case statements, but it doesn't seem to be working in my favor so hopefully someone can help me out,
Thanks!