I have attached a pic of the detail view showing how the call list is created with a button to take the user to the correct list. I have configured it this way so all users can see each others and head of sales can determine other peoples lists.
the expression for each list is
OR(AND(IN( [County], SELECT( User Assign Details[Counties To Include], [Unique Id] =“Call List 5” ) ),IN( [Outlet Rating], SELECT( User Assign Details[Outlet Rating], [Unique Id] =“Call List 5”)),
IN( [Price List], SELECT( User Assign Details[Price Band], [Unique Id] =“Call List 5”)),
[Next Call]>TODAY()-200,
OR(
[Assign Outlet to User]=USEREMAIL(),[Assign Outlet to User]=“”,[Assign Outlet to User]=“NONE”)),
AND([Assign Outlet to User]=USEREMAIL(),[Next Call]>TODAY()-200))
I can change the “my Call list” slice to the same but based on USREMAIL() but everytime I cange the call list expresssion I have to rfigure out how to get the same exact result but with the current USEREMAIL()
Th is is what I had in the My call List Slice but it didn’t result in the the same slice. I thought it would be easier to just redirect to the other one.
OR(
AND(IN( [County], SELECT( User Assign Details[Counties To Include], [User Id] =USEREMAIL() ) ),
IN( [Outlet Rating], SELECT( User Assign Details[Outlet Rating], [User Id] =USEREMAIL())),
[Next Call]>TODAY()-200),
AND([Assign Outlet to User]=USEREMAIL(),[Assign Outlet to User]=“”,[Assign Outlet to User]=“NONE”,
[Assign Outlet to User]=USEREMAIL(),[Next Call]>TODAY()-200))
thank
Phil