Solved

Pivot table - Calculate field

Posted on 2015-01-12
3
90 Views
Last Modified: 2015-01-16
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
Comment
Question by:Karl001
3 Comments
 
LVL 49

Accepted Solution

by:
Rgonzo1971 earned 250 total points
ID: 40546088
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
 
LVL 92

Expert Comment

by:Patrick Matthews
ID: 40546645
A sample file would be helpful
0
 
LVL 20

Assisted Solution

by:ltlbearand3
ltlbearand3 earned 250 total points
ID: 40548221
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
ADD New Entries 7 16
Excel copy picture into Outlook email 7 47
Excel 2016 formulas 5 32
In this macro, I would like to be prompted for a folder. 7 28
Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

26 Experts available now in Live!

Get 1:1 Help Now