0
1
Is it possible to have a multiple search criteria in Excel?
Is there any way to use logical constructs like OR etc. in filter criteria of a pivot table?
Update : In the filter options ( when one click the triangle in the caption of the field) the filter for "Begins With:" can only be used to filter only on one set of characters, e.g. find all the items that begin with "ABC" only, but I want to filter the items that beging with "AB" or CD" only.
In Sql this is a no brainer with the "like 'AB%' or like 'CD%'" , but I want to do the filtering in the pivot table.
Arjang
Posted 2012-02-29T01:52:57.937
Reputation: 522
1You can use advanced filters. What exactly are you trying to accomplish? Some details would be helpful in determining how you can accomplish it. – Raystafarian – 2012-02-29T11:04:27.967
@Raystafarian : In the Pivot table, With any text field, when trying to filter there is only one way of filtering "Begins with" and there is no wat to say filter Items begining with "K" and "C" only. – Arjang – 2012-03-03T03:51:03.140
Use filters instead of a pivot table – Raystafarian – 2012-03-03T12:15:07.543
@Raystafarian : Ray, I have the data in the Pivot table, That is how they are eant to be summurized. What do you mean to use Filters instead of PT? I just want to get the results that match a criteria in the Pivot Table. – Arjang – 2012-03-03T19:46:58.980