Interactive Filter on User's Organization

[Luiz Lucena]

Hello everyone, 

We have a request to create a report showing all tickets (INC, SCTASK, etc) where the caller is anyone under John Doe's Org. 
For example:
John Doe is the manager for PersonA, PersonB and PersonC, each one of those are also manager for more people. 
And some of those subordinates may also be managers for someone else.

We have a dashboard showing the ticket volume, for example, opened and closed during the month. It works with multiple interactive filters, assignment group, location, etc. 

Would be possible to achieve something like that through interactive filter?
Or anyone have a better idea to achieve that?

Thanks in advance,
Luiz

[Mike_R]

Assuming you are using the "Company" field, something like this should work

[Luiz Lucena]

Thanks, Mike.

That field is empty for us.

Here is a sample of a filter I did in one report:

Org in that case would be all employees under a VP, for example.

[Mike_R]

Sorry I misinterpreted your original question!

That's a little tricky. You might need to get into creating a custom interactive filter or a client callable script include (such as the example here - https://www.servicenow.com/community/developer-forum/list-all-employees-who-tree-up-to-a-manager/m-p...)

Another option, maybe make the report dynamic, such as

Affected User. Manager (is dynamic)  Me

Affected User. Manager. Manager (is dynamic)  Me

Affected User. Manager. Manager. Manager  (is dynamic)  Me

This way the report automatically updates based on the logged in user, and then no need for another interactive filter.