Restrict Selectable values of prompt based on selected value of another prompt

[hem852]

Hi

I have a prompt page on a report on which I need to allow users to select forecast types. I need them to select only 2 forecast types, no more, no less and the forecast types they select must be different.

Tried this in a single multiselect value prompt but couldn't find a way of ensuirng  the user selected exactly 2 forecast types.

Now I am trying two separate prompts each allowing selection of a single forecast type. This works in so much as the user must select exactly two forecast types however, it still allows the user to pick two identical forecast types.

Is there a way to make the second of my two forecast types prompts only show values other than the one selected by the user at the first prompt? 

TIA

John

[Stejawh]

Can you try a filter in the second prompt.

Something like

Forecast Version <> ?Forecast Version1?