Forum Discussion
Inner join in a slicer
I have two tables, Table1 and Table2, that are linked by the column "customer" that they both have. Table2 have more customers than the Table1, so its a one-to-many type of link. I would like to get an slicer with de field "customer" from Table2, but showing only the customers that Table1 have (like an inner join would do).
It doesn't work for me to just make the slicer with the "customer" from Table1, due to the data structure.
Any help is welcomed.
Thank you,
AgustÃ.
2 Replies
Try activating the Cross Filtering option.
Table on the many side does not filter the Table on One Side (unless Cross Filtering is on)
Hi,
Could you define the larger question please. What are you trying to do? What result do you want?
