Using OR condition to filter Pivot Table

whoiswct

New member
Joined
Nov 24, 2012
Messages
57
Reaction score
0
Points
0
I need the pivot table filtered results to be inclusive.

So, I have a table with some data rows and 3 Columns A, B, C with possible values X, Y, Z... I specify a filter for columns A, B, C such as that I can retrieve the data rows that have A=Y OR B=Z OR C=X.

The problem I have is that the default filters use an AND condition. So if I select the first value as A=Y, it will remove all other rows.

Any ideas? I know that you can do something similar with an Advanced Filter, but I don't know if there's a simpler solution.

Many thanks!

Sent from my phone using Tapatalk
 
Can you possibly create another column that combines the 3 columns into 1, then you can filter for those conditions all within that column?
 
Can you possibly create another column that combines the 3 columns into 1, then you can filter for those conditions all within that column?
Logically work but in reality not work.
Because the value in column A,B,C are 'date' value. If combine, it will be meaningless.


Sent from my phone using Tapatalk
 
You can put the variable in 3 separate cells,

then add a formula like:

=OR(A2=$X$2,B2=$Y$2,C2=$Z$2)

where A2:C2 are your first 3 items in your data to check against the dates in X2:Z2. If any match a TRUE is returned. You can filter that column.
 
attached a sample data. pls advise if I want to select date1=2012-04-31 or date2=2012-04-31 or date3=2012-04-31.
I want to have some feasibility to select any date from date1, date2 and date3
 

Attachments

  • Book1_filter_OR_sample.xlsx
    13.7 KB · Views: 403
Why the Pivot Table for this? There is the same info in both.
 
sorry, i don't know what u mean.
the attached sample xls is a dummy data. It is help to explain my case.
you can use it to demostrate your suggestion.
Thanks.
 
See attached.
 

Attachments

  • Copy of Book1_filter_OR_sample.xlsx.xlsx
    14.1 KB · Views: 387
See attached.
 

Attachments

  • Copy of Book1_filter_OR_sample.xlsx.xlsx
    14.6 KB · Views: 1,549
See attached.
Thanks for your advise. but it is not my expectation method.
I hope I can choose the Date(s) from the drop down list directly.
Anyway, I know it may be the limitation in Pivot Table.
 
Back
Top