# Excel07 - pvt tbl - calculated field question

#### tagoso

##### New Member
Hi,
I have a few thousand lines of data.
Each line contains;

Date: ProjectName : HoursWorked

I have successfully created a pivot table showing number of hours for each project and I can even filter by month.

What I want to do now is create a calculated field which tells me how much money those HoursWorked cost us. Each month the accountant gives me the total \$ figure for labour expense. I divide this by the total number of hours worked in that month to give me an average rate per hour. I would then like to apply that rate to each project and get a cost of labour for each project.

I have tried creating a calculated field but Excel wont let me reference a cell external to the pivot table (namely the average hourly rate).
Any brilliant ideas?
bryan

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

##### MrExcel MVP
Hi - welcome to the board!

you can't use a different constant for, eg, each month break in a calculated field. You'll need to have a single value for the lot, or add what you need to the data & let the pivot do the work.

Replies
3
Views
300
Replies
1
Views
381
Replies
2
Views
44
Replies
1
Views
265
Replies
12
Views
194

1,191,717
Messages
5,988,258
Members
440,146
Latest member
rgomes8

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back