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
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