Skip to Content
0
Jan 12, 2011 at 01:58 PM

Count Business Partner with restrictions

39 Views

Hi all,

following data structure:

BusinessPartner Attr1 Counter

900001 ab 1

900002 xy 1

900003 xy 1

900004 ab 1

900005 xy 1

900002 ab 1

900003 ab 1

900004 xy 1

900005 ab 1

Resulting in:

Attr1 Counter

xy 4

ab 5

How do I answer this question: How many BusinessPartner do have u201Cxyu201D AND u201Cabu201D? The answer would be 4, but the query counts 9u2026any suggestions/hints? I want to count the intersection and nothing elseu2026