Hey Guys Happy Friday,
I'm currently having trouble with accomplishing a task. Basically I have a dataset that contains People and the amount of time they have dedicated to specific work codes.
What I'm trying to do is get a grand total for each person per code to see how much time overall was dedicated to each code per person.
Here is a small sample of the dataset:
| ID | Name | Code Group | Time on Code |
| 1 | Dean | Admin | 7.25 |
| 2 | Sean | Tech | 2.5 |
| 3 | Mark | Tech | 3.5 |
| 2 | Sean | Charge | 7 |
| 1 | Dean | Admin | 6.5 |
| 3 | Mark | Admin | 5.75 |
| 1 | Dean | Tech | 5 |
| 3 | Mark | Tech | 6.75 |
| 2 | Sean | Charge | 7.25 |
| 1 | Dean | Tech | 7.25 |
| 3 | Mark | Charge | 1.25 |
| 2 | Sean | Admin | 4.75 |
| 2 | Sean | Admin | 4.75 |
| 1 | Dean | Admin | 6.25 |
| 3 | Mark | Charge | 4.5 |
| 1 | Dean | Charge | 7.25 |
| 1 | Dean | Charge | 7.25 |
Cheers to anyone in advance and my apologies if this is something simple that I just cant see
