2 Replies Latest reply: Jun 27, 2016 11:31 PM by ji xiaoquan RSS

    Get The Name of Top 1 Sales

    ji xiaoquan

      Hi everyone,

           I have a table about the sales,now I want to know who is top 1 order by the total sales.I want to show the Name in a text.

           QQ截图20160628104044.png

           I have use this :=if(Aggr(sum(Sales),name)=max(Aggr(sum(Sales),name)),name)

        but it does not work .

           Could you tell me how to solve this problem?