I am creating a report on
Object1__c. I have more than 3 users in my account.
When I create a report, I am trying to filter with the value of current user's custom field value.
User is the parent to
Object1__c & also
I am planning to update current user custom field (project name) from
object__2(which is the parent of
object2__c single user having a single record only.
How use current user custom field value in
Object1__c filter from
object2__c or from user.