Creating a prompt for only certain members from the same heirarchy

[WKar]

So in one heirarchy we have our regions and countries listed together at the same level. However I want to simply create a prompt listing only the 4 regions.  So what I have done is wrote the following expression in a Calculated Member:

IF (?Region? = [Americas])
then ([Americas])
else if (?Region? = [Asia Pacific Total])
then ([Asia Pacific Total])
else if (?Region? = [Total EMEA])
then ([Total EMEA])
else ([USA])

When the drop down displays, it shows Americas in the drop down and not the others. Is there something wrong with my expression? What am i missing? thanks!

[wyconian]

Hi

You're only getting one value in the prompt because ?region? has only one value.

I think I understand what you're trying to do but I think you're making it too complicated.  If you only want the 4 region values displayed in the prompt try using static choices in the property pane for the prompt.  You can type in whatever names you want but make sure the static choices match the values in the database (case, spelling etc). 

The downside to this is that if there is a new region it won't be automaticaly added to the prompt values, you will need to manually add any new values to any reports that use the prompts so the maintenance overhead may be quite high