Pivot Table Calculated Fields
 

Hello All -

I have a pivot table with a "count of outcome" field as my data as well as
my row field. There are three possible outcomes, (A, B, and C) I want to
calculate the % of only outcome C.

I tried a calculated item, but got an error because I already use outcome
twice.

Any Suggestions?

Marc

Pivot Table Calculated Fields
 

In your source data, add a column named Pct
In that column, enter a formula to calculate if the outcome is a C. For
example: =IF(A2="C",1,0)

Then add that field to the pivot table, as Average of Pct

Marc wrote:
Hello All -

I have a pivot table with a "count of outcome" field as my data as well as
my row field. There are three possible outcomes, (A, B, and C) I want to
calculate the % of only outcome C.

I tried a calculated item, but got an error because I already use outcome
twice.

Any Suggestions?

Marc


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