3 Replies Latest reply: May 21, 2012 2:33 PM by Phaneendra Kunche RSS

    total of top 5 rows--pls help

    Sonika Jain

      Dear all,

      Please help me on calculation of sumof top 5 rows from a set of records.Ex:I have Division and Balance.

      I need to display the sum of top five balance, and the balance for rest of the divisions, something like .

      Sum of   top 5 divisionsValue(sum (BALANCE))
      OthersValue(sum(BALANCE))

      I am writing expressions (for sum top 5)  as - if(Division = 'Sum of top 5 divisions', sum(if( rank(aggr( sum(BALANCE),DIVISION),4)<6,)...but this is not working..Please help me with the expressions

       

      Thanks,

      Sonika