J
jerry
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
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