I have created a Custom field in Opportunity Root level which is an Indicator and this field has been extended to OpportunityHeaderandItem data source as well.
I have created a custom report on top of OpportunityHeaderandItem DS.I have a requirement to restrict the data view of the report based on the following scenarios.
Scenario 1: Opportunities with the Custom Indicator set
Logged In user can see only the Opportunities in which he is a part of Sales Team.
Scenario 2: Opportunities with the Custom Indicator Not set.
Logged In user can see all such Opportunities even if he is not a part of Sales team.
In general if there are a total of 10 Opportunities in the system in which 5 Opportunities having the Custom Indicator set and remaining 5 with the Indicator not set.
Among the 5 Custom Indicator set Opportunities if the Logged In user is a part of Sales team for 2 Opportunities.
Then while executing the report he should see only 7 Opportunities in total excluding the 3 Custom Indicator set Opportunities from his view.
I have tried the relative select approach for Employee field but it is not having the Option to select MySalesTeam and also I am not sure how to apply the second level of restriction by checking the Custom Indicator field.
Kindly provide your valuable inputs here for achieving this requirement.