Scenario:
The Web TimeSheet administrator needs to create a report that shows the hours entered by a user against each project as a percentage of the total hours entered by him for the month and would like the report to group rows by user name and project name and column by project name. Please find attached the screen shot of the report.

Resolution:
To resolve the issue, you cannot run any project report. Run the TimeSheet Detail report. Open the Settings page and enable the following fields:

  • Month (Entry Date)
  • Total Hours
  • Project Name
  • User Name
  • Total Hrs (In Month)

Create a custom column by named Percentage with the value TotalHours/ (TotalMonthHours).

Note: When you group rows by user name and then by project name and column by Project Name, you need to have user name set to none, total hours set to sum and percentage set to sum under Summary Options.