3 Replies Latest reply: Mar 31, 2017 3:42 PM by Sunny Talwar RSS

    Get Max field value with the Max result in an expression

    Max Shevchenko

      Hi,

       

      Plan:

      LOAD * INLINE [

      Channel, Plan

      Retail, 100

      E-commerce, 50

      Wholesale, 20

      ];

       

      Concatenate(Plan)

      Fact:

      LOAD * INLINE [

      Channel, Fact

      Retail, 70

      E-commerce, 20

      Wholesale, 20

      ];

       

      PlanFact:

      LOAD Channel,

        sum(Fact)/sum(Plan) as Result

      Resident Plan Group by Channel;


      Drop Table Plan;

       

      I need get value in Text object from a 'Channel' field with the maximum result.


      In this case must be "Wholesale"


      If possible please add it to the file.

      Thx.