You can use Resource Usage Spreadsheet (Reports ribbon) to get Resource Utilization based on a defined time period. To change the period, right-click on the Timescale > Edit Timescale.

Note that only the child level Resources that are visible in the Resources window will be displayed in the Spreadsheet -