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