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
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.
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
Ken Puls, FCPA, FCMA, MS MVP
Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!
Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter
If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.
So you retrieve it every day. That is an easily automated task.
What version of Excel are you on?
excel 2010
Sent from my phone using Tapatalk
The I suggest that you use PowerPivot to query the data source and manage it there.
I'm thinking that this is heavily related to this thread. Let's keep the replies there until we sort the base issue out.
Ken Puls, FCPA, FCMA, MS MVP
Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!
Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter
If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.
Bookmarks