Listbox value on dimension?

[n1ef5ng1]

Hi

I have a selection panel (listbox) where it is customized

This listbox basically use the expresion and have fields like

if(Country = indonesia and Direction = North, North Indonesia) etc etc

Meaning there is a customized field that needs to fulfill two condition.

Now I would want my table on the dimension to show the field that the user select

Meaning on the dimension, i would want my table to show North Indonesia.

I tried text(   ) but it does not work

any advice

[Anonymous]

Hi, not sure if I understand you correctly, please correct me if I am wrong. Based on my understanding, you have two fields which are Country and Direction, Country field contains values like "Indonesia","Singapore","Malaysia"...etc where Direction field contains values like "North","South","East","West". Now, you want to have one selection box which is only one listbox to have selections like "North Indonesia","West Indonesia","South Indonesia","East Singapore"...etc and then you want your table to show the Country Region according to user's selection.

In order to achieve that, you can use expression: Direction&' '&Country as your listbox expression and your table dimension.