4 Replies Latest reply: Aug 30, 2017 7:24 AM by Sunny Talwar RSS

    RANK WHEN USING PICK MATCH FUNCTION

    Wale Martins

      Hi there,

       

      I want to add a Rank function in the following expression that I'm using as a dimensión in a straight table:

       

      =PICK(MATCH($Field,'TAG_COMPROMISO_SECTOR','TAG_ANALITICAS','TAG_VETSICS','TAG_MERCHANDISING','TAG_RESPONSABILIDAD_SOCIAL'),

             [TAG_COMPROMISO_SECTOR],[TAG_ANALITICAS],[TAG_VETSICS],[TAG_MERCHANDISING],[TAG_RESPONSABILIDAD_SOCIAL])


      I'm using that expression as dimension because I want to join different column values in a unique dimensión and count the number of times that appear each value in my main table.


      =COUNT (DISTINCT ID_VISITA)

      Untitled picture.png

       

      My problem is that I want to Rank the dimensión expression.... for example, only showing the top 5 count values but without using dimensión limits because in some cases I don't have to take into consideration the top 5 values for example...

       

       

      Any idea would be appreciated.

       

       

      Wale