4 Replies Latest reply: Nov 14, 2017 8:57 AM by João Vieira RSS

    Set Analysis

    João Vieira

      Hello community, i am trying to create a KPI that returns the country of the customer that has the more sales, to get the customer i used this expression:

      concat(aggr(if(rank(sum({$<Year={'$(vMaxYear)'},OrderDate={'<=$(vMaxDate)'}>}SalesFinal))<2,Customer),Customer),',')

       

      Now the idea is to select the country of the person that the expression returns, any ideas?

      Thank you for the help