1 Reply Latest reply: May 7, 2012 11:04 AM by Daniel_C RSS

    Highlighting Dimension in Table depending on Selection

      Hi @all,

       

      I'm trying to highlight dimension values based on a specific selection. The problem is that it only works for one selection, but not for two or more.

       

      I hope these pictures illustrate, what I mean:

       

      Unbenannt2.png

      With one selected value it works. Axpo is highlighted correctly.

       

      Unbenannt.png

      But with two (or more) selected values it doesn't work.

       

       

      The formula I use in the dimension expression of the table "Rankingtabelle" is:

       

      =if(Sponsor_Sel>0 AND WildMatch(Sponsor_Conc, Sponsor)>0, RGB(255,0,0), RGB(0,0,0))

       

      Sponsor_Sel: =GetSelectedCount(Sponsor)

      Sponsor_Conc: =Concat(DISTINCT Sponsor, ';')

       

      I hope anybody can help me! Thanks a lot in advance

       

      Daniel