Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table % calculation | Excel Discussion (Misc queries) | |||
How to Add a Calculation to a Pivot Table ? | Excel Worksheet Functions | |||
pivot table % calculation | Excel Worksheet Functions | |||
Pivot Table % calculation | Excel Worksheet Functions | |||
Referring to Pivot Table in Excel 2003 | Excel Worksheet Functions |