Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
i want to display top 10 lowest value based on sales
any one help? thanks,....
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)