Intersection in Alternate States

Wed, 19 Aug 2015 15:27:10 GMT

Dear ALL,

Greetings for the day!!!

I have an issue in Alternate Issues for finding the Intersection.

Scenario:

State A: Based on the selection of Products with >= Sales Value, the customers are listed.

State B: Based on the selection of Products with <= Sales Value, the customers are listed.

Now we need to have the common customers in both the states.

For Ex:

From the attachment,

Selecting Product 1, DALL,

Cust20000 DALL 11700

Selecting Product 2, OIL & RICE,

Cust10000 OIL 1400

Cust20000 OIL 5900

Cust10000 RICE 10300

NOw my result should be,

Cust20000 DALL 11700

Cust20000 OIL 5900

I am trying with,

=Sum({yes + no <Sales=P({<CustomerName = no::CustomerName>})>}Sales)

NOTE: yes & no is Alternate States.

Also attached the InputFile & my workings QVW file.

Please help me out.

Re: Intersection in Alternate States

swuehl — Wed, 19 Aug 2015 16:41:29 GMT

Maybe like attached?

Wed, 19 Aug 2015 18:35:42 GMT

Excellent. Correct Solution.