Hi all,

First timer here, so please be patient with me.

I have a timesheet that I receive every month - it shows what jobs the staff members did over the course of last month. I, in turn, have to generate a report that summarises their hours by the type of job they did and show how well they are doing by highlighting how much of their time is spent on the different types of jobs. Everyone works 7.5hrs/day and logs everything in, including holidays.

This is how far I got so far:

The timesheet worksheet looks like this:

3ol4pxj.png

I've turned that into a simple pivot table:

oZQZqdz.png

... and I would like for the pivot table to show me this:

XdTD8RY.png


I am fairly inexperienced in using pivot tables, so please be gentle

I've attached the xlsx file. Please help! Timesheet001.xlsx

Thank you.