Calculation referring to Pivot Table

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top