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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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 :-)