Here is the case. Base on a existing report, I need to create 2 straight table which only filter bySales Person and Payment mode.
1st table display list of products which the Customer Group has purchased. It should looks like this:
Group Name
Product
Asia Grp 1
prod1, prod2, prod6, prod11
Asia Grp 2
prod3, prod4, prod5, prod6
Eur Grp 1
prod11
US Grp 1
prod 10, prod11
2nd table display list of products which a customer has purchased. It should looks like this:
Customer
Product
AAA
prod1, prod11
BBB
prod1
CCC
prod3, prod 4
DDD
prod 5, prod6
This 2 table can filter each other, as selection of a Group Name in the 1st table will filter 2nd table to display Customer belongs to that group. when a selection of a Customer, 1st table should display the Group information which this customer belong to.
So I create Product field as expressions like this:
It looks OK, but once I click on a Customer, the Customer Group will display the product purchased by the selected customer instead of the product purchased by the Group.