The number of fields should be the same, whether you use a calculated
field, or fields from the source data.

If you can use programming in the workbook, you could add a cell named
LaborRate, and allow users to type a rate there.
Then add the following code to the pivot table's sheet module:

'=======================
Private Sub Worksheet_Change(ByVal Target As Range)
Dim ws As Worksheet
Set ws = ActiveSheet
If Target.Address = ws.Range("LaborRate").Address Then
ws.PivotTables(1).CalculatedFields("3q05 labor $"). _
StandardFormula = "='3q05 Labor Hrs'*" _
& ws.Range("LaborRate").Value
End If
End Sub
'======================

Linda wrote:
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...


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