How to filter out records and dependency on other column

[whoiswct]

How to filter out records and dependency on other column?
I have attached a sample data to elaborate my problem.

Assumption: the source data cannot be modified.
I want to show the FAMILY which have at least 1 "F" in SEX column.

[Bob Phillips]

Add a column to the data with a header of say Test and a formula of

=COUNTIFS($A$1:$A$14,A2,$C$1:$C$14,"F")>0

Then add Test to report filter on the pivot and filter for True

[whoiswct]

Add a column to the data with a header of say Test and a formula of

=COUNTIFS($A$1:$A$14,A2,$C$1:$C$14,"F")>0

Then add Test to report filter on the pivot and filter for True

Sorry to inform you that I cannot modified the data source.
I connect as external data source since it is modifying regularly so that I will not copy to local.

[Ken Puls]

Sorry to inform you that I cannot modified the data source.

So why not retrieve it to an Excel table. It will still update for you when you open the workbook. Base your PivotTable off the table in the workbook, and you can do what you like to that data source...

[whoiswct]

So why not retrieve it to an Excel table. It will still update for you when you open the workbook. Base your PivotTable off the table in the workbook, and you can do what you like to that data source...

If I retrieve to an excel table, it will become a offline data only but not a live data.
The source excel data is modifying every day.

[Bob Phillips]

So you retrieve it every day. That is an easily automated task.

What version of Excel are you on?

[whoiswct]

excel 2010

Sent from my phone using Tapatalk

[Bob Phillips]

The I suggest that you use PowerPivot to query the data source and manage it there.

[Ken Puls]

I'm thinking that this is heavily related to this thread. Let's keep the replies there until we sort the base issue out.