Above is an image of the actual data. The first problem which is depicted above is that there can be multiple Bucketing values for a given order. I need to attribute other lines within the same order to either Bucket or neither depending on the value of prodcat. The second, and bigger proglem I think, (sorry I wasn't clear in the first question) is that a given prodcat can apply to more than one "Bucketing" category, and the value I assign to Bucketing for a given prodcat depends on the value encountered on the order for Bucketing. This problem is depicted in the following images. In the first image, all lines where prodcat is 20 should be assigned a Bucketing value of CPAP, whereas in the second image all lines where prodcat is 20 should be assigned a Bucketing value of BiPAP. Thanks again for your time!
... View more