11 Replies Latest reply: Sep 28, 2017 2:13 PM by Vishnu Chakravaram RSS

    Color expression based on rank(measure)by row

    Pranahitha Nellutla

      Hi Can we color the background cell in a table

      I want to rank the measure in for each(Title col) using colormix gradient.

       

      I am trying to work with this code here

      Colormix(aggr(rank(sum([# Apps])),[Row dimension]),,RGB(67,89,56),RGB(x,y,z)

       

      sample data.

        

      titleJanFebMarAprMayJunJulAugSepOctNovDec
      A387817974254286437502454704265516499
      B1,3491,5018198061,1188157352,6691,5056096751,302
      C19,71618,17717,08216,17019,12421,19720,41720,96321,11318,21916,83815,830

      Something like attached.

       

      Rank 1 in each row will be one color,rank 2 in each row will be second color etc.

        

       

       

      thanks