when i am using dynamic prompt with single value, it is always selects blank and value. so it contains two values in dropdown list even i choosed non blank value option during prompt creation.
this dropdown prompt(second prompt) value is depending on the column(first prompt) in thet table. so i am selecting the column2 value depending on the value from column1 in table
It should display the value directly instead of selecting fron dropdown list.
Any one can help me in this