I am looking to create an excel table so i can review my colleagues performance on a certain area in work. The two measurement areas are Resolved Problems and Total time spent. I can pull this info from a dashboard at the end of the week and manually input it to excel.

We have 6 members of the team and i want to be able to input this data as weekly totals per user.

I will then use this data to track trends like who is resolving most problems, who is doing the least. Who spends the most time on problems and who spends the least.

I am not sure the best way to go about this data capture in excel.

Any help is appreciated.

CodePudding user response：

Isn't this something that you would right click, select pivot table, and pivot my person, value column of time, sort by time?

CodePudding user response：

I'm not sure. I want to trend peoples progress on a weekly basis on problems resolved and time spent resolving problems. I can't figure out the correct way to set up the table to just input the data.