Hi Debra,
Thank you for your response, I originally had the $75 hard coded in the
formula but the request was to make it dynamic so anyone could enter any
dollar value & refresh the pivot to see the results. I could place the
calculation in the source data worksheet but the file & existing pivot are
pretty large. I would have to add (to the pivot table) 8 additional fields (8
quarter forecast) to an existing 16 calculated fields. I'm concerned that
the table will be too big and will not calculate. So I tried to change the
formular to ="=3q05 labor Hrs*(average(labor rate))" but I had no luck with
it. Do you think some kind of "IF" statement might work...
--
Linda


"Debra Dalgleish" wrote:

Either calculate the dollars in each line of the source data, and add
that field to the pivot table, or change your formula to

='3q05 Labor Hrs'*75

Linda wrote:
answers to you questions:
1) the calculated field formula for 3q05 Labor $ is "=3q05 labor Hrs*labor
rate"
2) the results I'm looking for is to be able to enter any labor rate and
model the dollars impact.
__________________________________________________ _________________
I've worked on the file since my last e-mal and have abit more information.
It would appear that the calculation method used between "Sum of 3q05 Labor
Hrs" and "Sum of 3q05 labor $" are different (see below). The 3q05 labor
dolars should total 15 (hrs) * 75 (labor rate) = $1125 and not $1500. It
seem to be getting confused (or me) because item #1 has multiple records
(item 1 has multiple tasks being performed with different task durations but
the same rate, thus has different hrs between one another).

example of pivot table
item Sum of 3q05 Labor Hrs Sum of 3q05 labor $
1 10 $750
2 5 $375
____ _____
Grand Total 15 $1500

Example of source data
item 3q05 Labor Hrs labor rate
1 5 $75
1 5 $75
2 5 $75




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html