I want to restrict a user in a database with multiple dimensions, using and ‘OR’ rather than ‘AND’. I’ve seen the question asked in the forum but I haven’t seen the answer.
Here’s the use case:
A divisional sales manager is responsible for the product sales in a particular product division across the company but he is also responsible for sales for his specific sales team which sales products across all dimensions.
Can I set up a database restriction which shows him only sales for his division and sales for the salesperson on his team regardless of division?
example: Division = ‘Plumbing Supplies’ OR Salesperson = ‘Bob’, ‘Sally’, ‘John’