Skip to Content
0
Former Member
Mar 17, 2009 at 06:21 PM

Multiple combination of filter values - Please help

42 Views

We have a query with three filters. One for Sold-To (with optional entry) and another for Ship-To (with optional entry). The thrid filter condition is based on cal month/year.

Now, the user wants the following way ( and they don't want to use the single values or ranges from the filter options)

First filter condition - Sold -To (ABCD) and Ship To (EFGH)

Second filter condition - Sold -To (JKLM) and Ship To (NOPQ)

Third...

Fourt....

Fifth......

upto 10 filter conditions..

With the common Cal month/year filter.

How can we achieve this? Advance Thanks.

BW Learner