8 Replies Latest reply: May 5, 2016 6:45 AM by Мария Кияшко RSS

    Need help with expression

    Мария Кияшко

      Hi all!

      Here is my problem: I have two dimensions, A and B, and I have data C: C=AxB (there is C value for each pair (A,B)). Also, I have a formula: KPI=A*1000/(C*10*B). So, I have to get A-values, for which KPI, calcuted with grouping by B field, is MAX.

       

      I know how to calculate MAX KPI grouping by B field:

      =aggr(max(aggr(A*1000/(C*9.81*B),A,B)),B),

      but how to get B value?