Boolean Values in Pivot Table
 

I have a pivot table feed off a table 2 column talbe with booleans in teh
second column. I want te count the TRUE occurences. However the Count
property of the Field is counting both TRUE and FALSE answers. How do I only
count the TRUES?

OR do I have to use a COUNTIF in a manually created table?

Thanks

EM

Boolean Values in Pivot Table
 

Merely place the 2nd column in your row fields and filter by only True.

"ExcelMonkey" wrote:

I have a pivot table feed off a table 2 column talbe with booleans in teh
second column. I want te count the TRUE occurences. However the Count
property of the Field is counting both TRUE and FALSE answers. How do I only
count the TRUES?

OR do I have to use a COUNTIF in a manually created table?

Thanks

EM