pivot tabel subtotals

[edracer8]

Pivot table subtotals

I have created a pivot table to track employee daily hours and overtim
for a specified period of time (monthly). In this pivot table I hav
grouped the dates by week to show total hours worked. I have the
created a formula on a calculated field to show the number of overtim
hours worked each week. (i.e. hours worked – 40). I have als
created another calculated field to show the percentage of overtime fo
each week. Now, I want create a subtotal for each employee by that wil
show the total hours worked, and the total overtime hours. When I us
the subtotal function (within the pivot table), the total hours worke
is ok, but the subtotal overtime hours are calculated as they are i
the calculated field, thus not giving me the total overtime hours fo
the specified period. Can you tell me how to create subtotals that wil
show the total hours worked, total overtime hours and the percentage o
overtime hours. Note the example below.



Month Oct

Maintenance Emp Date hrs charged overtime OT %
avila, gabrielviz
9/26/2004 - 10/2/2004 53.5 13.5 25.2%
10/3/2004 - 10/9/2004 59.0 19.0 32.2%
10/10/2004 - 10/16/2004 52.5 12.5 23.8%
10/17/2004 - 10/23/2004 61.0 21.0 34.4%
avila, gabrielviz Total 226.0 186.0 82.3%

barnett, robert
9/26/2004 - 10/2/2004 55.0 15.0 27.3%
10/3/2004 - 10/9/2004 48.5 8.5 17.5%
10/10/2004 - 10/16/2004 58.0 18.0 31.0%
10/17/2004 - 10/23/2004 55.0 15.0 27.3%
barnett, robert Total 216.5 176.5 81.5

 

[ExcelProf]

Excel help states: If a field contains a calculated item, you can't
change the subtotal summary function.

So, even the Custom Subtotal feature probably isn't available for the
problematic field.

I'll be interested if anyone provides a solution.

ExcelProf