Pivot Table Calculated Field

[Branno]

Hi There,

In the past I have been able to use one or a number of the calacluated field within a pivot table to calculate further fields. For example for each employees I had sum of hours worked & sum of amount paid then could use these fields to calculate the average hourly rate by creating my own & dividing one into the other . For some reason when I go into my current pivotable i don't have the option in the drop down menu to use an already calulated field in my required formula?

Anyones assistance would be greatly appreciated.

Many Thanks


Branno

[tuph]

It would help us analyse the problem if you could attach a sample of your workbook. Remember to replace any sensitive or confidential data before uploading. To find the attachment options in your post click on <Go Advanced>.