- Open the Manage Relationships window from the Modeling tab and select the Sales to Product relationship.
- Modify the relationship between Product and Sales to Both for the Cross filter direction.
Bi-Directional Relationship Configuration (Both) from Edit Relationships Dialog
- Filter selections on one of the other dimension tables (Customer or Date) now also filter the Product table:
- Filtering on the male gender reduces the Product table to only the rows associated with a sale to the male gender.
Bi-Directional ...