Calculation referring to Pivot Table
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 |
All times are GMT +1. The time now is 03:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com