I have one dimension "Employee" and want to assign two products A and B. Product A and Product B are two line items formatted as Product List.
It is perfectly fine if employee is assigned the first product however, when the employee is assigned product B, then product A should not be visible in the dropdown as the employee has already been assigned.
Employee Product A Product B
John Screws Nuts
When John is being assigned Nuts then Screws should not be visible in the drop down.
Seems like a simple situation but I am struggling to make the logic.