There may be times where the available filters in the Report Center are insufficient. In this case, how to create a custom query?
In the Report Center-More screen, a custom query can be used to filter report data. You will need to know the database table, field you wish to filter and proper values for that field.
In this scenario, the project's Custom 2 field is used for the office location. You can now filter by this field and show only data related to office 36.