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