Executive Level Resource Capacity Reporting

Hello Team - we are currently having a really hard time taking vision to reality. Consider the Resource Grid, where human resources are grouped by team or manager(S). Our executives have multiple layers below them, so it is the ability to group resources into a meaningful organization and show the planned hours across a defined period of time that is paramount for our executives to look at their tower and use the data to make informed decisions on scheduling work. We've consulted with Workfront, but the limitation we see is that while we can get the planned hours by resource (user report), the planned hours cannot be reported in a way that shows hours planned across a given time period (week, month, quarter, year). Likewise, the resource grid lacks the ability to see beyond the individiual resource level. While this is ideal for true resource managers, it lacks what we need for executive level reporting. Has anyone found a solution for creating executive level organizational capacity reports?