Pivot Table Calculated Fields

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
 
D

Debra Dalgleish

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table, IF function, calculated item versus calculated field 1
Problem inserting calculated pivot fields into Pivot Table (2007) 1
Delete calculated field 1
Problem with Calculated item in Pivot Table 1
Pivot Table calculated item 4
Pivot table formulas 1
Pivot Table Calculated Field - Sum/count 1
Delete Pivot Table Formula 1

Top