Boolean Values in Pivot Table

E

ExcelMonkey

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table filter list - listing irrelevant subcategorys 1
Pivot Table 1
Using text values in Pivot Tables 5
Pivot Table 3
Pivot Table counting values 1
pivot table 1
Pivot Table counting a range 1
Pivot Table 1

Top