3 Replies Latest reply: Apr 30, 2013 5:46 AM by Michael Jordan RSS

    pivot_expression

      Dear all

       

      Seek your expertise. I have a pivot table as below:

      DirectionNo of AccountApproved Limit (RM'm)=Aggr(Sum(TMLimit),TM)/ Sum({$<TM-={9700}>} TMLimit)
      Non Target124770.029837476
      Selective422,3820.043216205
      Target85090.038476882

       

      I failed to get the desired result for last column as below

      14%

      71%

      15%

       

      rgrds