Forum Discussion

Aceplante's avatar
Aceplante
Copper Contributor
Sep 21, 2021
Solved

Count on pivot table

I am trying to count the number of "YES"s in a column on one sheet, and display the total on my pivot table. I can do count (but that just displays the total number of answers, regardless of them bei...
excel
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Sep 21, 2021

    Aceplante 

    Drag the field in the rows area and in the values area.

     

Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Sep 21, 2021

Aceplante 

Yes, the pivot table contains only the field with YES/NO.

 

Aceplante's avatar
Aceplante
Copper Contributor
Sep 21, 2021
??? so how do i count and tally up the number of yes's?
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Sep 21, 2021

    Aceplante 

    Drag the field in the rows area and in the values area.

     

Resources