[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 104
  • Last Modified:

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
0
Karl001
Asked:
Karl001
2 Solutions
 
Rgonzo1971Commented:
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
 
ltlbearand3Commented:
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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now