Display Top N%

[balanandam]

Hi all,

I'm presenting sample data here and I need to display top 5 %'s

Sample Data

Load * Inline

[
Customer, Sales
A, 100
B, 120
C, 300
D, 400
E, 75
F, 50
G, 125
H, 2000
I, 250
];

Added calculated dimension as

=IF(Aggr(Rank(SUM(Sales),4),Customer)<=5,Customer)

expression as

SUM({<Customer = {"=Rank(SUM(Sales),4)<=5"}>}Sales)

here I need to avoid highlighted row. Adding sample app here. Pls. advise.

Br, Balanandam

[balanandam]

Hi Paul,

thanks for response. this is helpful in my other cases.

Br, Balanandam