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
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
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS 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.
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
THIS SOLUTION IS 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.
SOLUTION
THIS SOLUTION IS 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.
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 :-)
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 :-)
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
