How can I set report critera depending on information related to the current user?

How can I set report critera depending on information related to the current user?

Hi,

I couldn't set report criteria depending on information related to the current user.

For instance,  if I want to show record from a specific table, I have another table that relates each email with a country, and I want  to show only the records  that  the "country" field is filled with the same country as the current user.

 

something like this: "country == User (email==zoho.loginuser).country"

 

I  also tried with user defined functions but reports doesn’t like them

cheers!

Javier