Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have a problem , any help is appreciated.
As below table. I want to add a list box to filter Product. It can show lines which buy both Product A & Product B .
Now, if I select Product A & Product B from the list box , it will show any Order No which contain Product A & Product B. Like below Result.
But , actually I don't want to show lines expect Product A & Product B.
Is there any possible way to achieve it ?
Thanks in Advance!
Table:
Order No | Customer | Product |
001 | Wu | A |
001 | Wu | B |
002 | Li | C |
003 | Yang | A |
003 | Yang | B |
003 | Yang | D |
004 | Zhao | E |
Result:
Order No | Customer | Product |
001 | Wu | A |
001 | Wu | B |
003 | Yang | A |
003 | Yang | B |
003 | Yang | D |