Expression for sum of top 5 rows

[sonikajain]

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 divisions	Value(sum (BALANCE))
Others	Value(sum(BALANCE))

I have created dimensions - sum of top 5 Divisions and Others as an inline table.

I am writing expressions (fo value corresponding to r 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

[#2]

Hi,

Please try writing each of these expressions in text boxes to see if the values are coming. For us to debug, please share a sample of your application.

Regards,

Kiran Rokkam.