Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering Pivot Table Data
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 "x" in pay grade "y". 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 "vacant" for incumbent, for example, all other fields dragged in (pay grade or position number) return as "blank". 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
OLAP Pivot table - How to show items with no data ? | Excel Worksheet Functions | |||
Pivot table Data area show/hide behavior | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Change Data In Pivot Table | New Users to Excel |