Pivot Table formula help! Add field that divides 2 others

[Asher]

I have a pivot table (new to these).

The two fields from my table that I am trying to use are:

1. Group ID
2. Executed

I am trying to find the percent executed per group.

My pivot table has these fields:

1. Group ID
2. Count of Group ID
3. Count of Executed

I want the last field to be:

% of Executed = Count of Executed / Count of Group ID

I have read about inserting calculated columns but nothing tells me how to calculate formulas based on other calculated pivot table fields, only on the original table fields..

There has to be a way this can be done.

Any suggestions? Was I clear enough

[HansV]

Click anywhere in the pivot table.
Click Formulas > Calculated field.
Make it look like this:

x573.png

The calculated field will operate on the totals automatically.
Format the calculated field as a percentage.