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
Bookmarks