Skip to Content
0
Former Member
Jan 31, 2007 at 08:18 PM

Query Modeling Scenario

17 Views

HI All,

Here is a scenario i am trying to model in a Bex Query.

Original Record set

Customer Material Value $

ABC XYZ 100

ABC EFG 200

ABC HIG 300

CBA XYZ 100

LMN XYZ 100

The requirement is to find all customers who have ONLY purchased Material = XYZ and no other product. This means that Customer ABC who has Purchsed XYZ is to be excluded from the results since he has bought other products also.

The result of the query should be

Customer Material Value $

CBA XYZ 100

LMN XYZ 100

Please help how to model this query. Points galore for people who has a solution....

Thank You