I have a Pivot table from a large Spreadsheet (3500 Rows) which reflect the
outages of 1500 applications. Most have not had any outages. When i create my
Pivot table I need to be able to sort the results be different groups, Sales,
Marketing for example. The Sales Group might have 50 applications and
Marketing 75 app but they are diff apps with some over lap.

right now i am manually reviewing the list selection drop down on the field
area and selecting the applications.

My question is this: Is there a way to filter the selection based on some
sort of list either on another tab or inserted somewhere