Timesheet report summarized by month/year

Forum|Forum|8 months ago
June 26, 2025
2 replies
621 views

Hello,

I'm trying to create a report in WF Global that shows the total hours an employee has entered in a month for a project, without showing entry by entry. So, for example, I'd like to see:

Project 123456 - Employee John Doe - Month June 2025 - Total hours 56

I've tried using the Total Hours option, but it still shows time entry by time entry. How could I force the report o summarize by month not using Matrix?

Thanks.

Workfront

Best answer by JustinRenteria2

You should use an Hour Report instead. Group the Hour report in Matrix mode by:
Row Grouping: Owner > Name, Project > Name
Column Grouping: Hour > Entry Date (select the summarize by month option).

JustinRenteria2Accepted solution

New Participant

You should use an Hour Report instead. Group the Hour report in Matrix mode by:
Row Grouping: Owner > Name, Project > Name
Column Grouping: Hour > Entry Date (select the summarize by month option).

JustinRenteria2

New Participant

Just saw that you wanted Project first so just switch the two fields in the Row grouping above

F

FernandaPaAuthor

New Participant

Thank you, but I don't want the matrix view. I'd like the details tab to be a table with hours by month/project/owner, without using the groupings. The idea is to be able to extract that and send to clients.

Sven-iX

New Participant

This might fit the bill - so you can either report on

hours
work items/assignments

The latter gives you the sum, see example here

F

FernandaPaAuthor

New Participant

Thank you, but what I need is a data dump of the hours by month/project/owner. A table without groupings. Is it possible?

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded