Pivot table - Calculate field

Hi,

In my PivotTable, I have the calculate field:

=IF('Status CE'="Yes";1;0)

The result is always 0, even I have some 'Status CE' with Yes as value.

Any idea why it's doesn't work?

Thanks
Karl001Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Rgonzo1971Connect With a Mentor Commented:
HI,

As far as I know Excel cannot use text in calculated field, you could add a column in your source data with your formula

Regards
0
 
Patrick MatthewsCommented:
A sample file would be helpful
0
 
ltlbearand3Connect With a Mentor Commented:
I agree with Rgonzo that I don't believe you can use text in a pivot table to tally results.  As he suggests adding a column will work or another idea, if you cannot modify your source data, is to just add the Status CE column as a row or column filter.  Then you can just run a count of the Status CE column.  You will end up with a Yes column in the pivot table with a nice count of how many had Yes.  See the mockup sample attached.
Q-28595100.xlsx
0
All Courses

From novice to tech pro — start learning today.