Excel Pivot Table Filter : Items Begining with “A” or “W”?





.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}







0















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.










share|improve this question




















  • 1





    You can use advanced filters. What exactly are you trying to accomplish? Some details would be helpful in determining how you can accomplish it.

    – Raystafarian
    Feb 29 '12 at 11:04











  • @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
    Mar 3 '12 at 3:51











  • Use filters instead of a pivot table

    – Raystafarian
    Mar 3 '12 at 12:15











  • @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
    Mar 3 '12 at 19:46


















0















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.










share|improve this question




















  • 1





    You can use advanced filters. What exactly are you trying to accomplish? Some details would be helpful in determining how you can accomplish it.

    – Raystafarian
    Feb 29 '12 at 11:04











  • @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
    Mar 3 '12 at 3:51











  • Use filters instead of a pivot table

    – Raystafarian
    Mar 3 '12 at 12:15











  • @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
    Mar 3 '12 at 19:46














0












0








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.










share|improve this question
















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.







microsoft-excel microsoft-excel-2010 pivot-table






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Mar 3 '12 at 3:55







Arjang

















asked Feb 29 '12 at 1:52









ArjangArjang

3641420




3641420








  • 1





    You can use advanced filters. What exactly are you trying to accomplish? Some details would be helpful in determining how you can accomplish it.

    – Raystafarian
    Feb 29 '12 at 11:04











  • @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
    Mar 3 '12 at 3:51











  • Use filters instead of a pivot table

    – Raystafarian
    Mar 3 '12 at 12:15











  • @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
    Mar 3 '12 at 19:46














  • 1





    You can use advanced filters. What exactly are you trying to accomplish? Some details would be helpful in determining how you can accomplish it.

    – Raystafarian
    Feb 29 '12 at 11:04











  • @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
    Mar 3 '12 at 3:51











  • Use filters instead of a pivot table

    – Raystafarian
    Mar 3 '12 at 12:15











  • @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
    Mar 3 '12 at 19:46








1




1





You can use advanced filters. What exactly are you trying to accomplish? Some details would be helpful in determining how you can accomplish it.

– Raystafarian
Feb 29 '12 at 11:04





You can use advanced filters. What exactly are you trying to accomplish? Some details would be helpful in determining how you can accomplish it.

– Raystafarian
Feb 29 '12 at 11:04













@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
Mar 3 '12 at 3:51





@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
Mar 3 '12 at 3:51













Use filters instead of a pivot table

– Raystafarian
Mar 3 '12 at 12:15





Use filters instead of a pivot table

– Raystafarian
Mar 3 '12 at 12:15













@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
Mar 3 '12 at 19:46





@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
Mar 3 '12 at 19:46










1 Answer
1






active

oldest

votes


















0














Try filtering on at least one blank row above Pivot Table as well as Pivot Table.






share|improve this answer
























    Your Answer








    StackExchange.ready(function() {
    var channelOptions = {
    tags: "".split(" "),
    id: "3"
    };
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function() {
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled) {
    StackExchange.using("snippets", function() {
    createEditor();
    });
    }
    else {
    createEditor();
    }
    });

    function createEditor() {
    StackExchange.prepareEditor({
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: true,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: 10,
    bindNavPrevention: true,
    postfix: "",
    imageUploader: {
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    },
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    });


    }
    });














    draft saved

    draft discarded


















    StackExchange.ready(
    function () {
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f395178%2fexcel-pivot-table-filter-items-begining-with-a-or-w%23new-answer', 'question_page');
    }
    );

    Post as a guest















    Required, but never shown

























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    0














    Try filtering on at least one blank row above Pivot Table as well as Pivot Table.






    share|improve this answer




























      0














      Try filtering on at least one blank row above Pivot Table as well as Pivot Table.






      share|improve this answer


























        0












        0








        0







        Try filtering on at least one blank row above Pivot Table as well as Pivot Table.






        share|improve this answer













        Try filtering on at least one blank row above Pivot Table as well as Pivot Table.







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Jul 12 '12 at 8:12









        pnutspnuts

        5,61032239




        5,61032239






























            draft saved

            draft discarded




















































            Thanks for contributing an answer to Super User!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid



            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.


            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f395178%2fexcel-pivot-table-filter-items-begining-with-a-or-w%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            Popular posts from this blog

            Plaza Victoria

            Puebla de Zaragoza

            Musa