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
Can you try a filter in the second prompt.
Something like
Forecast Version <> ?Forecast Version1?