Pivot table % based on subtotal (2003)

[srizki]

I am using Excel 2003

In my pivot table, column A has employees name, column B, has Project name, column C has, I called it FILTER, column D has some of total and E has %.
An employee may have more than one project (rarely though). but each employee has more than one FILTER, that really is productivity, like, non productive, productive service, productive warranty etc.
I want the percentage on column E to be calculated per employee base and I know that it it not possible in pivot table before 2010 version.
Is there a way around?

Thanks

 

[srizki]

I am using Excel 2003

In my pivot table, column A has employees name, column B, has Project name, column C has, I called it FILTER, column D has some of total and E has %.
An employee may have more than one project (rarely though). but each employee has more than one FILTER, that really is productivity, like, non productive, productive service, productive warranty etc.
I want the percentage on column E to be calculated per employee base and I know that it it not possible in pivot table before 2010 version.
Is there a way around?

Thanks

column A has at the end of each cost center, the cost center and TOTAL, so for example 110296 TOTAL
1101515 TOTAL