software

My source worksheet has a position number, specialty rating, pay grade,
incumbent name, etc. In the past I have successfully used Pivot Tables to
answer questions such as how many vacancies do I have for specialty rating
quot;xquot; in pay grade quot;yquot;.

In an attempt to ensure greater data integrity, HR sent me an extract from
their system in an .xls format. After setting up a Pivot Table with HR's
data and attempting to filter in the same fashion I cannot filter more than
one field. If select only quot;vacantquot; for incumbent, for example, all other
fields dragged in (pay grade or position number) return as quot;blankquot;. Checking
the drop down filters for these fields in the pivot table, I find that all of
the choices are selected, they just aren't displayed.

What might I be missing or doing wrong?