Top 10 low values

[arulsettu]

Hi

i want to display top 10 lowest value based on sales

any one help? thanks,....

[MK_QSL]

Something like below

1)

Dimension

Customer

Expression
SUM({<Customer = {"=Rank(-SUM(Sales),4)<=10"}>}Sales)

2)

Dimension

Customer

Expression

SUM(Sales)

Dimension Limits

Tick Restrict which values are ....

Show Only Smallest 10 Values

Untick Show Others

3)

Calculated Dimension

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

Tick Suppress When Value is NULL

Expression

SUM(Sales)