Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have 3 fields
manager ,employee, salar
for under each manger i want show top 10 salryed employess in in straight or pivot table
Please help me on
Thanks,
For a straight table try this as the expression to show top 10 Salaries for each manager
if( aggr( rank( sum( Salary)),Manager,Employee) <=10, sum(Salary))
to actually show the rank as well
if( aggr( rank( sum( Salary)),Manager,Employee) <=10, aggr( rank( sum( Salary)),Manager,Employee))
For a straight table try this as the expression to show top 10 Salaries for each manager
if( aggr( rank( sum( Salary)),Manager,Employee) <=10, sum(Salary))
to actually show the rank as well
if( aggr( rank( sum( Salary)),Manager,Employee) <=10, aggr( rank( sum( Salary)),Manager,Employee))
Dimension
1) Manager
2) IF(Aggr(Rank(SUM(Salary),4),Manager,Employee)<=10,Employee)
Expression
SUM(Salary)
in a straight table you can also use dimension limit (in dimension limits tab)