K
Kris W
A B C D E F G H
1 Sum of Total Hours
2 Name Area Activity WE Total Total (blank) Percentage
...6 Area Total 0.00 hrs
0.00%
...12 Name Total 0.00 hrs
I have a pivot table summarising staff timesheets which looks like the above
(hopefully it makes sense!) - columns A through F is the pivot table, G is a
blank column, H is the column I'm trying to calculate.
I am trying to put a calculation to automatically calculate the percentage
of the total hours of an area of work against a persons total work hours, and
so it will update when the pivot table is updated.
Some people have a large number of different pieces of work and some will
have only one.
Has anyone got a suggestion on how I could do this - or if it is possible?
Cheers!
Kris
1 Sum of Total Hours
2 Name Area Activity WE Total Total (blank) Percentage
...6 Area Total 0.00 hrs
0.00%
...12 Name Total 0.00 hrs
I have a pivot table summarising staff timesheets which looks like the above
(hopefully it makes sense!) - columns A through F is the pivot table, G is a
blank column, H is the column I'm trying to calculate.
I am trying to put a calculation to automatically calculate the percentage
of the total hours of an area of work against a persons total work hours, and
so it will update when the pivot table is updated.
Some people have a large number of different pieces of work and some will
have only one.
Has anyone got a suggestion on how I could do this - or if it is possible?
Cheers!
Kris