Results 1 to 2 of 2

Thread: Pivot Table Filter

  1. #1

    Pivot Table Filter



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello everyone,

    I have a pivot table like below.

    how can I only show the data with AO and MH in HOME_DEPT (only abaker)? aallen and abyrd no show. Thank you

    First name/ Last Nam HOME_DEPT EMP_NAME
    aallen MH ALLEN, AMY
    ALLEN, AUSTON

    abaker AO BAKER, ANTHONY
    MH BAKER, APRIL

    abyrd MH BYRD, AISHA
    BYRD, APRIL

  2. #2
    The way I would do it is create another column next to it and use a mid function to pull in your AO and AH and then name the column and update your pivot then drag that column in filter then filter for what you like.

    Im not sure if that mid function is correct but it is some type of function to draw out the AO or AH you are looking for. I would have to see it to know for sure. Cheers!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •