Need help with slices please

[AL_Shaikh_Real_]

Table: Users

User_name	User_email
Oliver	Oliver1111@gmail.com
Khalid	Khalid2341@gmail.com
Yaom	Yaom2211@gmail.com

Table: S_Req

Req_id	First_user_name	Entery_Date	Offer_Status	Last_user_name	End_date
3d3464fe	Oliver	12-4-2021	available
75920828	Yaom	15-4-2021	In negotiation	Khalid	19-4-2021

Req_id UNIQUEID()

First_user_name SELECT( Users[User_name],([User_email] = useremail() ))

Entery_Date Today()

Offer_Status ENUM

Last_user_name ifs([Offer_Status]=" In negotiation",SELECT(Users[User_name],([User_email] = useremail() )))

End_date Today()

I need to have condition in the (Slices Source Table (S_Req)) to show only if

• [Offer_Status] = “In negotiation”
• Email of [Last_user_name] = useremail() ??? I need it to chick the email from the table Users because I’m having name in the field [Last Username] not an Email