Hi All,
Need your help but I dont know if what I want is possible... I'm a newbie by the way so please pardon me should I have done anything wrong by posting this query. I searched in the other sections and couldnt find anything similar to my dilemma.
Ok, so I have a worksheet where data is either YES or NO. There are other columns as well so I decided to use pivot to get the count of each column. However, when it comes to these variable data, pivot just counts everything (both YES/NO). Is there any way that the count will just show yes?
Thanks! Hope you guys can help me..
Bookmarks