Intersection in Alternate States

[#1]

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.

[swuehl]

Maybe like attached?

[#3]

Excellent. Correct Solution.