find in a straigth table a selected dimension

[#1]

Hi,

I cant' figure out this issue.

I have an application with a lot of charts.

One of them is a straigth table which is independant of the selection. The dimension of this table is CITY.

A user have to select in a list box a CITY.

My objective is to color or highligth in the table the selected CITY to find easily where is the selected CITY.

Maybe I have to use the background color of the dimension but I don't know how.

Thanks for any help

JJJ

[#2]

any idea ?

[pover]

Try putting the expression

=if(match(MonthYear,$(Selected_MonthYear)),lightgreen())

in the background color of the dimension and in the variable Selected_MonthYear I put

=chr(39)&getfieldselections (MonthYear,chr(39)&','&chr(39))&chr(39)

The example is attached. I hope that is what you were looking for.

Regards.

[#4]

Thanks Karl it works well !!

I still don't understand the expression =chr(39)&getfieldselections (MonthYear,chr(39)&','&chr(39))&chr(39)

even it works.

regards

jjj

[pover]

Maybe with all the chr(39) it looks confusing, but it is just so you can create a list with singles quotes like 'Ene','Feb','Mar'. The getfieldselections returns a list of values and I want to declare my separator as a ',' but if a put ',' the expression will think I just want a , without quotes so I have to put chr(39)&','&chr(39) to get ',' and then I need a singel quote at the beginning and end or the list.

In that way you can form a dynamic match that in this case ends up being

match(Month,'Ene','Feb','Mar')

because match(Month,Ene,Feb,Mar) doesn't work.

I'm glad it works.