Pivot Table Calculated Fields

  • Thread starter Thread starter Marc
  • Start date Start date
M

Marc

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
 
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
 
Back
Top