7 Replies Latest reply: Feb 26, 2018 8:17 AM by Sunny Talwar RSS

    Issue with Rank Function

    omar bensalem

      Hi all ( stalwar1 )


      I have sthing in mind but I can't figure out a way to do it; Let me explain:


      I have one dimension : ClientName

      I have on measure: sum({1}Hits)

      I've created a text field: its goal is to give back the rank of each clientName once selected :

      subfield(aggr(rank( sum({1} NbHits), ClientName),ClientName),'-')

      This will work, when we select one ClientName, It returns its Rank.

      But now, I got yet another requirement which is :

      I select 3 clients for example: I sum up their Hits. and see their combined rank (if these 3 clients were 1 client, where would they Rank?)


      Hope that was clear?

      Ps: I'm not even sure this is possible!

      Hope someone would help !