Pivot Charts: Presenting a list of fields that have a particular value in one row but not the other

[up2mylife]

I have a set of data for our company's sales representatives in each country, the amount of data is huge and I'm trying to find a way to represent in a pivot chart (or table) the list of countries that have female representatives but no male representatives..
So I've made a pivot table with the row labels being country, and column being gender, and values count of gender. so its not this but it is similar to this just with a lot more data:

https://www.dropbox.com/s/m8bj6s55a4qm6xd/444.png

and I want to present the countries in a chart or a table that have female representatives but no male representatives .. or if possible I want only these countries to show in that pivot table.. Is there a way to do this?

 

[etaf]

you should be able to filter the data using zero

 

[up2mylife]

There is a filtering drop-down menu for both the columns and rows but I cant find out where the filtering option for the values is..

 

[etaf]

anyway you can load a sample , maybe into dropbox, skybox or other online sharing

 

[up2mylife]

This is a sample.. I want to represent only the countries that have female representatives but no male representatives:

https://www.dropbox.com/s/w7x6e3z9lbphg8v/Book2.xlsx

 

[up2mylife]

even when I do the value filter and set is equal to zero it filters all the values including the female column which I do not want to happen

 

[etaf]

i'm sure theres a way to do within the pivot table
while think about that
you could add two fields to the data and include those in the pivot table as a filter

MaleCnt
=COUNTIFS(B:B,"M",C:C,C3)
FemaleCnt
=COUNTIFS(B:B,"F",C:C,C3)
and copy both down

then use those fields in the filter
and you can choose 0
for male or female or both

not a great solution