View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default 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