Multiple combination of filter values - Please help

[Former Member]

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

[Former Member]

Hello

What you have to do is create a structure

In you first selection you take the SOLD TO and restrict to the value ABC then you take the SHIP TO and restrict the DEF then take the KF required.

In your next selection you do the same but with SOLD TO value GHI and SHIP TO value JKL and same KF and so on for the following selections.

The cal month year can be added too either through variable (in that case the selected period will applies to the whole query) or by restricting its value just like SOLD TO and SHIP TO.

You can not make multiple selection through variable unless you re run your query and change the value of those varaibles.

Another way is to display all possible combinations of SOLD TO and SHIP TO but I'd rather go for the first solution with the structure ... that will work fine

Rgds,