Sub items time tracking report

Hi,

I was hoping someone can help or give me a bit of guidance regarding my Monday.com board.

I have a board with a list of items which all have sub items. In each sub item there is a “People” column and “Time Tracking” column for recording time.

I would like to create a dashboard to give a total amount of time for certain people.

When I try to do this using the dashboards, there is no way for me to achieve this query. The time tracking widget does not allow me to track sub items time tracking.

Any help would be greatly appreciated.