Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Get the result from @prompt function!

Status
Not open for further replies.

fernanda

Programmer
Aug 8, 2002
11
PT
Hello!

When i put in a dimension:
"
<< table field>> IN @Prompt('Choose month','A','<<the right dimension>>',Multi,constrained)
&quot;,
is there a way i can use the result chosen by the user in other dimension?
Suppose the user chose 'January'.
If I have several measures that depend of the month chosen, how can i do that? Can I do a @select(dimension that as the prompt). Does this return me the result 'January'?

Thank you

Fernanda
 
Simply repeat the same @Prompt(...) everywhere you need that user response. It will only appear once when asking to the user, since the response name (first parameter) is the same. You could also use @Variable with the same response name.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top