Custom field in Pivot Table?
 

Hi. I have a Pivot Table that uses three fields from a source table:

Job Name
Points Done
Points Remaining

Each row of the source table is for a task that needs to be completed
in order to finish the job. So many rows will be for the same Job
Name. Each row is assigned points based on the complexity of the task.

I'm grouping the pivot table by Job Name. For each job name in my
source table, I am showing the sum of Points Done and Points Remaining.
So the Pivot table ends up looking like this:

Build John's House
Total Points: 100
Remaining Points: 40

Build Jane's House
Total Points: 100
Remaining Points: 80

What I want to do is add a custom field to the pivot table that tells
me % complete for each job. This would be done by having a pivot field
based on a formula that used Total Points and Remaining Points. The
goal is to have the pivot table look like this:

Build John's House
Total Points: 100
Remaining Points: 40
% Complete: 60

Build Jane's House
Total Points: 100
Remaining Points: 80
% Complete: 20

How can I tell the pivot table to add this % Complete field?

Thanks for any help!

Ken

Custom field in Pivot Table?
 

Right click on the pivot table select Formulas-Calculated field. Here is
where you can create a custom calculated field.

" wrote:

Hi. I have a Pivot Table that uses three fields from a source table:

Job Name
Points Done
Points Remaining

Each row of the source table is for a task that needs to be completed
in order to finish the job. So many rows will be for the same Job
Name. Each row is assigned points based on the complexity of the task.

I'm grouping the pivot table by Job Name. For each job name in my
source table, I am showing the sum of Points Done and Points Remaining.
So the Pivot table ends up looking like this:

Build John's House
Total Points: 100
Remaining Points: 40

Build Jane's House
Total Points: 100
Remaining Points: 80

What I want to do is add a custom field to the pivot table that tells
me % complete for each job. This would be done by having a pivot field
based on a formula that used Total Points and Remaining Points. The
goal is to have the pivot table look like this:

Build John's House
Total Points: 100
Remaining Points: 40
% Complete: 60

Build Jane's House
Total Points: 100
Remaining Points: 80
% Complete: 20

How can I tell the pivot table to add this % Complete field?

Thanks for any help!

Ken