Dynamic column change on selection

[abhijitnalekar]

Hi All,

I want to change the column name dynamically on the selection from list box.

Eg. Suppose i have USD,GBP,NOK.. etc values in a list box.

and we have different column in the database like USD_Amount,GBP_Amount,NOK_Amount.. etc

we want to create one variable which changes the the filed name on the selection..

Eg. if we select USD in the list box variable create a value like USD_Amount which is a field name. and that will change on the selection.  is this possible.

Thanks

[rafatashiro]

Hi,

U can create a variable like vCurrency, for example and in the variable definition u have to use something like that:

= if( isnull(GetCurrentSelections(CurrencyFieldName)), 'Select a Currency', CurrencyFieldName & ' Amount')

Then, in the Field Label of the Table/ Chart u use :

= $(vCurrency)

[rafatashiro]

Or u can try this:

U can create a variable like vCurrency, for example and in the variable definition u have to use something like that:

= if( isnull(GetCurrentSelections(CurrencyFieldName)), 'Select a Currency', Concat(CurrencyFieldName) & ' Amount')

Then, in the Field Label of the Table/ Chart u use :

= $(vCurrency)