Is it possible to have peer-to-peer comparison sheets with individual KPI sheets?

Summary

I’m basically trying to create a DB where Reps can only see their data according to tableau’s Username() matching on the server. Then on the other hand I want the managers of the Reps (and me) to be able to filter on any Rep. The problem is that I can accomplish Tableau recognizing who the user is, however, on sheets that compare the user to their peers, it’s filtering out their peers because they technically aren’t the person who’s accessing the DB. I’ve spent hours trying to solve this with...