TOP5 Customers based on sales

[Anonymous]

I want to display Top5 customers based on sales in straight table by using expression.

Only Top5 customers (Based on sales) should display, remaining customers should not display.

Please drop the solution here only as i can't open QVW file in my machine.

Customer	Sales
Alles Lusekofter	63.55
Art et Fashion	140.4
Aujourd´hui	343.44
Autokleider	205.2
Belgium Black	4048
Big Foot Shoes	95.9
Bobby Socks	163.36
Boleros	3931.22
Bond Ltd	21.36
Boombastic	185.2
Casual Clothing	332.64
Champes	182
Chateau de Ville	620.55
Cloe do Pau	3189.06
Copacabana	165.6
Da Bikini Expertu	796.4
Da Santho	2433.9
Das Alpen Shoe	77.97
Davenport Fash	617.4

[passionate]

Use calculated dimension as =Aggr(if(rank(sum(Sales))<=5,Customers),Customers)

Expresion as Sum(Sales)

[passionate · Accepted solution]

Also check suppress null option

[Anonymous]

Got it. Thank u so much friends.

[manoj217]

=concat ( IF( aggr ( Rank(sum(Sale)),Customer)<=5, Customer & chr(10)))

[pradosh_thakur]

please close the thread by marking someone's answer correct and the answer which helped you as helpful. you can mark more than one answer as helpful.

regards

Pradosh