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

Create a Calculated Field with the formula:

=('Total Points' -'Remaining Points' )/'Total Points'

Format the field as percentage.

(E-Mail Removed) 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
>


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html