PDA

View Full Version : Pivot Table Filter



ajen7118
2015-09-10, 05:24 PM
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

johnney12
2015-09-24, 08:48 PM
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!