Hi all!

Here is my dilema, I am running a pivot report for people that are not very savy, but like to play with data. I need to run a count but only for "Yes"responses in a field. In other words, if my table looks like this:

Y N
Y Y
YN

I don't want the pivot to calculate all the entries (Count = 6) but rather, just the ones that have a "Y" valu (count = 4) .

The reason for this is that I do not want to run the risk of someone changing the fields of the pivot and loosing an IF statment within the original data.

Thanks for your help!!!

Crey23