Filter / Query

[Nosh10]

Hello, 

After filtering on a product, I would like to show all customers that purchased that product in a table. Based upon the results, I  would like to see what other products those customers purchased in another table in the report. 

Example:

1. Select product A from filter

2. Click on a customer name based on the results from the filter 

3. Display all products that the customer purchased including product A in a different table 

* Product A is a mandatory selection 

Thank you.