Skip to Content
0
Former Member
Apr 11, 2005 at 08:52 AM

BEx query design: defining complex filters?

226 Views

Is it possible to define complex filters in a query definition? By complex I mean using logical operators (AND, OR, NOT)

Example: report giving sales results

I want to have

(Customers from Germany <b> AND </b> product type A)

<b> OR </b>

(Customers from Romania <b> AND </b> product type B)

If I define a standard filter:

Customer country IN (DE,RO)

Product type IN (A,B)

I will obtain all combinations while I only want to have the couples {(DE,A),(RO,B)}.

Thxs.

LauQ