Consider that you have below in your script... Below examples are for TOP 10 but you can change it for top 15.
Employee:
Load * Inline
[
Employee, Salary
A, 10000
B, 20000
C, 24000
D, 40000
E, 100000
F, 50000
G, 125000
H, 80000
I, 75000
J, 40000
K, 50000
L, 35000
M, 25000
N, 50000
O, 35000
P, 20000
];
===================================
1) Using Calculated Dimension
Dimension = Calculated Dimension
=IF(Aggr(Rank(SUM(Salary),4),Employee)<=10,Employee)
Tick Suppress When Value is NULL
Expression = SUM(Salary)
2) Using Set Analysis in Expression
Dimension = Employee
Expression = SUM({<Employee = {"=Rank(SUM(Salary),4)<=10"}>}Salary)
3) Using Dimension Limit
Dimension = Employee
Expression = SUM(Sales)
Dimension Limits
Select Show only Largest 10 Values
4) If you want to show in Text Box
=CONCAT(IF(Aggr(Rank(SUM(Salary),4),Employee)<=10,Aggr(Employee&CHR(9)&MONEY(SUM(Salary),'#,##0'),Employee)),', '&CHR(10),-Aggr(SUM(Salary),Employee))
5) Using Script
Employee:
Load * Inline
[
Employee, Salary
A, 10000
B, 20000
C, 24000
D, 40000
E, 100000
F, 50000
G, 125000
H, 80000
I, 75000
J, 40000
K, 50000
L, 35000
M, 25000
N, 50000
O, 35000
P, 20000
];
NoConcatenate
Temp:
Load Employee, SUM(Salary) as Salary Resident Employee Group By Employee;
NoConcatenate
Final:
First 10
Load Employee, Salary Resident Temp Order By Salary Desc;
Drop Tables Employee, Temp;
Hope this helps...
