1) Create a Straight table
Dimension
Customer
Expression
SUM({<Customer = {"=Rank(SUM(Qty),4)<=5"}>}Qty)
or
2) Create a straight table
Dimension
Customer
Expression
SUM(Qty)
Dimension Limit Tab
Tick Restrict which values are.....
Show Only Largest 5 values
Untick Show Others Option
Or
3)
Create a straight table or pivot table
Calculated Dimension
=IF(Aggr(Rank(SUM(Qty),4),Customer)<=4,Customer)
Tick Suppress When Value is Null
Expression
SUM(Qty)
