SOLVED

Count on pivot table

Copper Contributor

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 being YES or NO), and Distinct (but that displays 2, I assume for yes and no). In regular spreadsheets I could do countif (=Yes) but can you do that on pivot tables?

 

3 Replies

@Aceplante 

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

 

??? so how do i count and tally up the number of yes's?
best response confirmed by Aceplante (Copper Contributor)
Solution

@Aceplante 

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

 

1 best response

Accepted Solutions
best response confirmed by Aceplante (Copper Contributor)
Solution

@Aceplante 

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

 

View solution in original post