highlight row keep other data

[#1]

Hi Guys,

Have any of you guys come across a way to highlight the row selected in a straight table but KEEP all the other data?  I am looking to apply the functionality similar to a list box to a straight table.  When you select something from a list box the item selected stays white and everything else turns gray (BUT YOU CAN STILL SEE IT).  Is that possible in a straight table?

Message was edited by: Katie Webb

[#2]

Thank you so much, that is exactly what I was looking for.  Do you know the syntax of the expression if there are multiple dimensions?

I have put the background color expressions in each dimension but it only works properly if I select the first dimension.  I know I am missing something!

[#3]

Like this ?, good luck Katie!!!

[Clever_Anjos]

Well, I think you can use "and" operator

something like this

=if(Index(Dim1,Concat(distinct total Dim1,''))>0 AND Index(Dim2,Concat(distinct total Dim2,''))>0,LightGray())