I have a table which keeps a track of time spent on different projects by different people in a team. There are also different categories of work i.e. research, design, meetings etc. A typical record would be..
Project_No.: 1234
User: John Smith
Category:vResearch
Time_spent: 2 hrs
What I would like to see in a pivot table style view is, for each project, how much time in total has been spent on each category by the team. This would look something like...
Project_No.: 1234
Category: Research, 23 hrs
Category: Design, 75 hrs
Category: Meetings, 15 hrs
TOTAL: 113 hrs
In the same way I would like to list for each team member, how their time has been split across different categories...
User: John Smith
Research, 12 hrs
Design, 15 hrs
Meetings, 3 hrs
TOTAL: 30 hrs
What would be perfect for me would be to 'build' the report in real time as I would for example using Excel pivot table, say by using drop down box combinations??
I don't know if any of this is possible without some serious coding or not???
Thanks in advance. Steve
