PIVOT - COUNT IF "YES"

  • Thread starter Thread starter ant1983
  • Start date Start date
A

ant1983

Hi,

My pivot fetches the following from my data-source:

Column Labels:
Company Name (Value)

Row Labels:
IS - Date

Values:
Count of IS - Date
Count of IS - Attended

.... So it pushes out a table that shows me Company Name on the top, Date of
the Course on the left, and counts the number of times the course appears in
the datasource hence showing me how many people were booked for that course.
The only problem is the "Count of IS - Attended" doesnt work so well. That
foeld is populated with either a Yes or No or it is blank in the data-source
so it counts ALL the values.

I dont want it to count ALL the values but rather only the "Yes"

How do i do that?
 
You may be able to make the Attended field a column header. Then you'll get a
separate total/column for each entry in that attended column.

Or you could move the Attended field to a page field and choose to show just the
Yes's.

Or you could use a separate column in your raw data column:

=if(a2="yes",1,0)
(add headers and drag the formula down)
and use that in your pivot table.
 
Back
Top