1 Reply Latest reply: Sep 18, 2018 12:00 PM by Quy Nguyen RSS

    how to write the set expression for highest sale year?

    daisy ch

      Hi

       

      t1:

      LOAD * Inline [

      year,sales

      2010,100

      2010,200

      2011,500

      2010,600

      2012,300

      ];

       

      my requirement is in KPI i want show   highest sale year .the above liline table 2010 is the  highest sales year.

      i am writing below expression

      =max(Aggr(Sum(sales),year))

       

      it showinh highest sales value 900.but i need show year not sales value.

       

      how to write the set expression.

       

      Thanks