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.
