Avatar of agwalsh
agwalsh
 asked on

Count number of yeses in a field - via pivot table

hi Folks
I just want a pivot table to show me the number of yeses of up to date by department. I've attached a file. I'm wondering if I could do it via Calculated Field...
EE-Question-countif-for-pivot-table.xlsx
Microsoft Excel

Avatar of undefined
Last Comment
agwalsh

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Professor J

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Professor J

by the way your Antenatal Clinic count of yes is 5 not 4 as per your original data. please see uploaded attachment in my comment ID: 40868361
SOLUTION
Rory Archibald

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
Richard Daneke

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
agwalsh

ASKER
@Professor JimJam - sorry about the Antenatal count (what can I say...my abacus was at the menders........) @richard daneke. not sure what you mean by "did not host a pivot table" but actually it did...did think of Countifs but I'm doing this for someone and they are new to Excel so while I could do a countifs - using a pivot table gives more flexibility.  
Did the job - thank you. As it happened in the actual data I had more fields and I found that adding the field to the Report Filter list also gave me what I was looking for.
As always, thanks to you all :-)
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes