I could use some help with a Reports question.  I have a report where the' Show Me' filter is based on the ‘Created By’ field, however when a manager selects the 'My Team..' option I would like it to be based off a different field labeled ‘Assigned To’ field.  Is there a way to do one of the following?

1) Update the field that the 'Show Me' filter pulls from to be the ‘Assigned To’ field.

2) Set the 'Show Me' to all records and add an additional filter with logic to only pull in the running user's direct reports e.g. (user.id ==

CreatedById.user.manager.id).  I realize my formula will need some modifications.

Any input would be appreciated!