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:


      but how to get B value?