We currently have an additional custom user lookup field on Accounts called CS Rep. I am trying to dynamically run the report as if I were the CS Rep. This way I can run a single report to send to each CS Reps through a subscription. It would work the same as using the My Accounts filter, but with the CS Rep field instead of Account Owner.
Is there a way to do this? Trying to find an alternative to making 10 different reports filtered by each CS Rep.
Thank you so much!