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