Help with counting values in a pivot table

[dem1an]

I would use the count feature in a pivot, but I can only get this to work properly for 1 field column. However, I have several field columns that contain TRUE/FALSE that I want to count.

When I try to do a

=COUNTIF(K:K,"FALSE")
or
=COUNTIF(K:K,FALSE)

over the pivot data...nothing.

It will return 0 if the values are contained in the pivot. If of course I manually type FALSE to below the pivot it counts it. For some reason countif doesn't seem to work inside a pivot. Is there something I can do to manipulate Excel to make this work?

Does that make sense?

 

[Datsmart]

Take a look at this demo of setting up a calculated Fields in a Pivot Table:
http://www.datapigtechnologies.com/flashfiles/pivot4.html

It demos setting up a SUM, but you should be able to change it to your COUNTIF.

 

[dem1an]

This was a neat feature that I'm glad I now know, but it does not really apply since the fields I have is a true/false, not a number that can be added, etc. I'm just trying to get a count for true/false for more than one field ...right now the only solution I see is to have 3 pivot tables....and do a subtotal "count" on the outer most field.