This question may have a very obvious answer, however I need to ask it.  I am creating a report for one particular department.  No other departments will ever use it.  I have a list of values, however this department only uses about 10% of the list.  In my dynamic cascading prompt, I would really like to filter the topmost dropdown list so that the choices are only on the 10% of the items, without having to make the user choose from a list above this level.  Is there a way to filter the data that populates the topmost prompt?

You need Business View manager to filter the dynamic prompts. Open the prompt with DF at the end and set the filter.