I am an excel newbie, but I considered myself reasonably comfortable with Pivot table till i got stuck with this issue..
I need to count values of "Yes" by gender in the table below:
problem.png
The values field in Pivot-table does not have a COUNTIF that i could have used to count values of "Yes". So I thought of using a calculated field and inserting an if-clause there (if "Registered" is "Yes", then 1 , else 0) there, but even that is not helping.. I am getting all zeroes there..
Can anyone help?
(Remember this is dummy data. Ideally I can just change "Yes" to 1 and "No" to 0 in the source and proceed with sums, but unfortunately. in the actual problem that I am working on, I don't have access to the source data.)
I have attached the excel sheet if you want to play around with data.
Bookmarks