1 Reply Latest reply: Sep 11, 2015 5:58 AM by Sunny Talwar RSS

    How to use aggregate function

    Ruslans KLimovs

      Hello, Please help in a simple question!!

       

      I have the following table

      Client_Number  | Agetn_Name_in_STA | STA_Money_2015

      2                         Alex                                   14

      2                         Alex                                   1

      2                         Michel                                  11

      3                         Alex                                        3

       

      I use an aggregation function:

      =aggr(MAX(aggr(SUM(STA_Money_2015), Client_Number, Agetn_Name_in_STA )), Client_Number)

       

      As the result, I have MAX sum value in the column.

       

      How can I get no the MAX sum value, but the Agetn_Name_in_STA value, which have this MAX sum value??

       

      Thank you in advance!