How to set up filtering based on user to show only their data?
In my example, let's say we have a report called Weekly Sales Report. This report needs to be shared with 50 sales people and each person can only view their own sales. When I share, I know I can share with one user and apply the filter criteria of "Sales"."SalesRep"='
user1@mycompany.com'. However, I would have to do this 50 times while making sure I set the filter properly for each share.
Is there a more generic or global method to share once with all 50 sales people while making the filter apply specifically to each user? I guess I'm looking for some sort of filter like "Sales"."SalesRep"=
'zoho_user_id' that can be applied. I haven't found such an example yet while looking through the Help and Forums section.
Thank you in advance for any guidance.