Skip to Content
author's profile photo Former Member
Former Member

Multiple combination of filter values - Please help

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Mar 18, 2009 at 02:22 PM

    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,

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.