Calculated field in Pivot Table
 

I am having problems with a calculated field in a pivot table.

I believe the challenge is the in the way pivot tables summarizes then
multiplies.

For example

10/1/05 task 1 = 2.00 hours
10/1/05 task 2 = 3.00 hours
10/3/05t task 3 = .50

rate 50.00/hour

thus, as it is occuring now (2.00+3.00+.50=5.5 * 50.00) * 3


Instead what i am looking for in the above example is 5.5 hours *50.00/hr.

Any idea, how i can accomplish this?

thanks
Jerry