How to show top 5 customers contribution in funds

[mahnoor1279]

Hello everyone,

I want to show only top 5 customers having contributed in Each Fund, Can some one please help me out i didn't find any good help.

Output

FUND NO	TOP 5 CUSTOMERS CONTRIBUTION IN AMOUNT
13010001	=   (SUM AMOUNT OF TOP 5 CUSTOMERS) / (TOTAL                AMOUNT )
13010002
13010003
13010004
13010005
13010006
13010007
13010008
13010009
13010010
13010011
13010012
13010013

[BrunPierre · Accepted solution]

Try:

= Sum({<[CUSTOMER NO]={"=Rank(Sum(AMOUNT)) <=5"} >}AMOUNT)
    /
   Sum(TOTAL AMOUNT)